How to Change Date Format in Power BI Table Visualization

Getting your dates to look just right in a Power BI table can sometimes feel like a bigger challenge than it should be. You might have a perfectly good date column, but it shows up with the time included, a format that doesn’t match your region, or just isn't clean enough for your final report. This guide will walk you through several methods - from simple clicks to powerful functions - to take control of your date formats and make your tables clear, professional, and easy to read.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Date Formatting in Power BI Matters

Before we jump into the "how-to," let's quickly cover the "why." Proper date formatting isn't just about making things look pretty, it's about clarity and usability.

• Readability: A format like "January 25, 2024" is much easier for most people to understand at a glance than "1/25/2024 12:00:00 AM."
• Consistency: When all dates in your reports follow the same format, it creates a professional and polished look. Inconsistent formats can make your dashboard feel messy and untrustworthy.
• Regional Standards: If your audience is in the United States, they expect to see Month/Day/Year (MM/DD/YYYY). If they're in Europe, they expect Day/Month/Year (DD/MM/YYYY). Matching these standards is crucial for avoiding confusion.

In short, spending a few moments to get your date format right can significantly improve the quality and effectiveness of your reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: The Quickest Fix in the Data View

The simplest and most common way to change a date format is in Power BI's Data View (sometimes called the Table View). This method changes the format for the column everywhere it's used in your report, ensuring consistency.

Here’s how you do it step-by-step:

Step 1: Navigate to the Data View On the left-hand side of your Power BI screen, you'll see three icons: Report, Data, and Model. Click on the grid icon to enter the Data View.

Step 2: Select Your Date Column In the Data View, you'll see your tables laid out like a spreadsheet. Find the table containing the date column you want to format and click anywhere within that column to select it. The entire column should become highlighted.

Step 3: Access the Column Tools Once the column is selected, a new contextual tab called Column tools will appear in the ribbon at the top of the screen. Click on it.

Step 4: Choose Your Desired Format Within the Column tools tab, look for the "Formatting" section. You'll see a dropdown menu next to "Format." Click this dropdown, and Power BI will present you with a list of predefined date formats. Here are a few common choices:

• d/M/yyyy (e.g., 6/15/2024)
• dddd, MMMM d, yyyy (e.g., Saturday, June 15, 2024)
• MMMM d, yyyy (e.g., June 15, 2024)
• M/d/yyyy (e.g., 6/15/2024)

Simply click the one you want to apply. You should see the data in your column update instantly to reflect the new format. When you go back to your Report View, any table or visualization using that column will automatically show the newly formatted dates.

Method 2: Creating a Custom Date Format

What if the predefined options in the dropdown menu aren't exactly what you need? Power BI also allows you to define your own custom format.

To do this, follow the same steps as Method 1. But instead of choosing a format from the dropdown, you can type your own custom format code directly into the format box. Here are some of the building blocks for custom date formats:

• d: The day of the month (e.g., 5).
• dd: The day of the month with a leading zero if needed (e.g., 05).
• ddd: The abbreviated day of the week (e.g., Mon).
• dddd: The full day of the week (e.g., Monday).
• M: The month number (e.g., 3).
• MM: The month number with a leading zero (e.g., 03).
• MMM: The abbreviated month name (e.g., Mar).
• MMMM: The full month name (e.g., March).
• yy: The last two digits of the year (e.g., 24).
• yyyy: The full four-digit year (e.g., 2024).

Examples of Custom Formats

You can combine these codes in almost any way you like. Let's say your original date is "January 5, 2024."

• To get "Jan-2024", you would type: MMM-yyyy
• To get "Q1 2024", you can use: "Q"Q yyyy (Note: The letter Q is a special character for quarter).
• To get "05/Jan", you would type: dd/MMM

This method gives you complete control over how your dates are displayed to match your exact reporting needs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Using a DAX Function for More Flexibility

Sometimes, you might want to create a new, specially formatted date column without changing the original one. This is useful when you want to keep the original date column for chronological sorting or calculations while using a text-based version for display. The best way to do this is with the FORMAT function in DAX (Data Analysis Expressions).

Creating a new column with DAX ensures your original data remains untouched and you can easily switch between formats if needed.

How to Use the FORMAT Function

Step 1: Go to the Data View Just like in Method 1, navigate to the Data View.

Step 2: Create a New Column Select the table where you want the new date column. In the Column tools tab at the top, click on New column. Your formula bar will pop up at the top.

Step 3: Write your DAX Formula The structure for the DAX function is simple: ReportDate = FORMAT('YourTable'[DateColumn], "MMM yyyy")

Press Enter, and a new column called ReportDate will appear in your table with the text format.

Example: Displaying the Day of the Week

Now you can do something like this. If you want a column that shows the full day of the week, like "Monday," etc., you can create this: DayOfWeek = FORMAT('YourTable'[DateColumn], "dddd")

This gives you a new column with the day of the week associated with that date, which can be useful for analyzing performance by day of the week.

Potential Pitfalls and How to Overcome Them

Changing the date format can be straightforward, but there are ways to make mistakes or overlook issues. Here are some common pitfalls to fix:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Problem: Your Date Is Not Correctly Interpreted as a Date

A common problem with formatted dates arises when the column is actually a text field, not a true date field. Power BI can only apply "date" formats to columns recognized as date/time fields.

How to Fix: You can adjust a conversion error by clicking Transform Data on the Home tab. In the Power Query Editor, select your date column, click the data type icon (usually "ABC"), and change it to Date. This will ensure your data is treated as it should be whenever calculations or sorting take place.

The Problem: Your Dates Are Sorted Alphabetically, Not Chronologically

When you use the DAX function to create a string-based date, such as "MMM yyyy," your column will be sorted as text unless you specify the order. This results in an order like "April, August, December," rather than the expected chronological order.

How to Fix: If needed, you can set the sort order using the Sort by Column feature, which lets you use the formatted text column but maintain a logical ordering according to your original date column.

Final Thoughts

Changing the date format in Power BI can significantly improve the readability and professionalism of your reports. Spend some time experimenting with different formats to find what works best for your data and audience expectations. By learning to customize and apply date formats effectively, you ensure your reports communicate the right information clearly and help drive better decisions.

For more tips on Power BI, make sure to check other guides that cover visual interactions, data transformations, and reporting best practices. Explore Graphed to streamline your analytics and ensure a cohesive data strategy.