How to Change Date Format in Power BI Graph

Nothing clutters up a perfectly good Power BI graph like a long, clunky date format. You’re trying to show a clean monthly trend, but your x-axis insists on displaying "2024-10-25T00:00:00.000" for every data point. It’s frustrating, hard to read, and kills the professional look of your dashboard. This guide will walk you through the four main ways to change date formats in Power BI, from the quickest visual fix to the most robust and reusable methods.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Power BI Displays Dates This Way

Before we fix it, it helps to understand why this happens. Power BI loves data, and it tries to be as precise as possible. When it sees a date, it often loads it as a DateTime data type, which includes the full date, time, and sometimes even milliseconds. This precision is great for raw analysis but terrible for clean data visualization.

Clean, readable axes are essential for telling a clear story. Your stakeholders don’t need to know that sales data was pulled at midnight, they just need to see the trend for "October," "Q4," or "2024." Fixing this formatting is a fundamental step in building reports that are easy to understand at a glance.

Method 1: The Quickest Fix – Formatting in the Visual Itself

This is the fastest way to change a date format for a single chart. It’s perfect when you need a quick fix for one specific graph and don’t want to alter the underlying data model. Keep in mind that this change only applies to the visual you have selected.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Select the graph or visual you want to change. This will bring up the "Visualizations" pane on the right-hand side.
2. Click the paintbrush icon that says "Format your visual."
3. Find and expand the "X-axis" section (or "Y-axis," depending on your chart setup).
4. In the text formatting settings under "Values," you may see a "Display units" option, but what you’re really looking for is the date/time format field itself. Sometimes Power BI offers limited formatting choices directly here.
5. If available, you can select from the provided options. However, this method is often limited and may not appear for all visual types or data configurations. That's why the next method is considered the best practice.

This is a quick, on-the-fly adjustment, but for anything you plan to reuse, Method 2 is far more efficient.

Method 2: The Best Practice – Formatting the Column in the Data View

This is the most reliable and efficient way to control a date format. By setting the format at the column level in your data model, you ensure that any visual you create using that date column will automatically use the correct format. You set it once, and it stays consistent everywhere.

Step-by-Step Instructions:

1. On the far left-hand side of the Power BI interface, click on the "Data view" icon (it looks like a small spreadsheet or table).
2. From the "Data" pane on the right, select the table that contains your date column. The table will appear in the main window.
3. Click on the header of the date column you want to format (e.g., 'OrderDate'). This will highlight the entire column.
4. A new ribbon called "Column tools" will appear at the top of the Power BI window.
5. In the "Formatting" section of this ribbon, you’ll see a "Format" dropdown. Open it and choose your desired format. For example, selecting "Short date" will change 10/25/2024 12:00:00 AM to a clean 10/25/2024.

Creating Your Own Custom Date Formats

What if the preset options don’t have exactly what you need? For example, maybe you want to show the month and year as "Oct 2024." This is where custom formats come in.

In that same "Format" dropdown, instead of selecting a preset, you can type your own custom format code directly into the text box. Here are some of the most useful codes:

• d: The day of the month without a leading zero (e.g., 5).
• dd: The day of the month with a leading zero (e.g., 05).
• ddd: The abbreviated three-letter day of the week (e.g., Mon).
• dddd: The full day of the week (e.g., Monday).
• M: The month number without a leading zero (e.g., 9).
• MM: The month number with a leading zero (e.g., 09).
• MMM: The abbreviated three-letter month name (e.g., Sep).
• MMMM: The full month name (e.g., September).
• yy: The two-digit year (e.g., 24).
• yyyy: The full four-digit year (e.g., 2024).

You can mix and match these to create the perfect format. Here are a few practical examples:

• To get "October 2024", you would use: MMMM yyyy
• To get "Oct-24", you would use: MMM-yy
• To get "Q4-2024", you could use (note the escaped character \): \Qq-yyyy
• To get "Mon, Oct 25", you would use: ddd, MMM d

This method offers the best balance of control and reusability and is the recommended approach for most formatting needs.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 3: The Power Query Method for Pre-Transformation

Sometimes your date data arrives in Power BI as the wrong data type, like "Text." Before you can format it as a date, you have to convert it. The best place to handle data type issues and initial transformations is in the Power Query Editor.

Step-by-Step Instructions:

1. From the "Home" ribbon in the main report view, click on "Transform data." This will open the Power Query Editor.
2. Find and select the column with your date information.
3. Check the data type icon in the column header (e.g., ABC for text, 123 for number, a calendar for date).
4. If it’s not a calendar icon, click the icon and change the type to "Date" or "Date/Time." Power Query is smart and can usually interpret most common text layouts of dates.
5. Once it’s in the correct data type, click "Close & Apply" in the top-left corner.

After you’ve done this, Power BI will recognize the column as a true date field. You can then go back and use Method 2 to apply the specific display formatting you want across your report.

Method 4: The DAX FORMAT Function for Calculated Columns

For even more granular control, or when you need to create a new column with a specific text-based format for labeling purposes, you can use the DAX (Data Analysis Expressions) language. The FORMAT function is your tool for this job.

This method creates a new calculated column instead of modifying the existing one. This is key. The output of the FORMAT function is always a text string, not a date.

Step-by-Step Instructions:

1. Go to the "Data view."
2. Select the table you want to add the new column to.
3. In the "Table tools" ribbon at the top, click "New column."
4. A formula bar will appear. Here, you'll write your DAX formula.

The syntax is simple: FORMAT(<value>, <format_string>). You can use the same custom format codes from Method 2.

Example:

Imagine you want a column specifically for "Month-Year" labels, like "Jan-2024". The DAX formula would be: Month Year Label = FORMAT('Sales'[OrderDate], "MMM-yyyy")

When to Use DAX vs. The Data View Method

So why use DAX if it's more complex? Here’s a simple rule of thumb:

• Use Method 2 (Data View) when you want to change the visual display of an existing date column while keeping it as a true date data type. This is what you want 90% of the time.
• Use Method 4 (DAX FORMAT) when you need a brand-new column with a very specific text format for use in slicers, legends, or table labels, and you don’t need the behaviors of a "true" date (like continuous timelines or date hierarchies).

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

A Common Pitfall to Avoid: Incorrect Sorting

If you create a "Month's Name" column (e.g., "January", "February"), and you use it in a chart, Power BI will sort it alphabetically (April, August, December…), which isn’t helpful.

To fix this, you need to create another column for the month number (1–12). Then, in the Data View, select your text-based month column, go to "Column tools," and use the "Sort by column" feature to tell Power BI to sort your month names based on the month number column instead.

Final Thoughts

Adjusting date formats is a small change that makes a huge impact on the clarity and professionalism of your Power BI reports. By understanding when to use a quick visual format, a foundational column format, or a specific DAX calculation, you gain full control over how your data tells its story. This fundamental skill is a stepping stone to creating dashboards that people actually want to use.

While mastering the nuances of a tool like Power BI is a valuable skill, there are times when you just need a straightforward answer without an 80-hour training course. This is exactly why we built Graphed to help. Instead of clicking through menus to fix date Axes, you can simply ask, "Show me my Shopify revenue by month as a line chart." Our AI-powered analyst handles all the connections, formatting, and visualization automatically, freeing you up to focus on the insights - not the configuration.