How to Change Date Format in Power BI Slicer

Nothing sidetracks a great Power BI report faster than confusing date formats. While Power BI's slicers are fantastic for letting users filter data, they can sometimes default to a date format that isn't ideal for your audience, like showing MM/DD/YYYY when your users expect to see DD-MM-YYYY. Fortunately, fixing this is simple. This tutorial will walk you through the primary ways to change the date format in your slicer to make your reports cleaner and easier to understand.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Date Formatting in Slicers Matters

Taking a moment to standardize date formats isn't just about making things look tidy, it's about improving the user experience and ensuring clarity. A well-formatted date slicer is instantly readable and removes any potential for misinterpretation. Who hasn't stared at "03/04/2024" and wondered if they’re looking at March 4th or April 3rd? This ambiguity can be a significant roadblock, especially when your reports are shared across different regions or with audiences accustomed to various date notations (e.g., US vs. European standards).

Switching from a generic format like 3/1/2024 to a more explicit one like 01 March 2024 instantly makes your report more professional and universally understood. Clear formatting builds trust in your data and helps your audience focus on the insights, not on deciphering the presentation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Change the Date Column Format (The Easiest Way)

The most direct approach to changing the date format in a slicer is to change the format of the source column itself. This method is quick, easy, and will apply the new format to that date column anywhere you use it across your entire Power BI report, ensuring consistency. If you want the same format everywhere, this should be your go-to solution.

When you select a column in Power BI, a special "Column tools" tab becomes available in the command ribbon at the top of the window. This is where you can control the data type, summarization, and, most importantly, the format of the column's data.

Step-by-Step Guide:

1. Navigate to either the Report view (where you build visuals) or the Data view (where you see your tables) in Power BI Desktop.
2. In the Data pane, located on the right side of the screen, find and click on the name of the date column you are using in your slicer. For example, you might select the 'OrderDate' column from your 'Sales' table.
3. Once the column is selected, look at the top ribbon. You will see a new tab appear called Column tools. Click this tab to open it.
4. Within the Column tools tab, locate the Formatting section. You'll find a dropdown menu labeled "Format." It likely shows "Short Date" or another default format.
5. Click this dropdown menu. A list of predefined date formats will appear. Select the one that best suits your needs, such as "MMMM d, yyyy" to display a date like "January 30, 2024" or "dd-MMM-yy" for "30-Jan-24."

Once you make your selection, the date format in your slicer (and everywhere else that specific column is used) will update automatically. It's as simple as that.

What if Your Desired Format Isn't Listed?

Power BI offers incredible flexibility with custom format strings. If the built-in options aren't quite right, you can define your own format directly in the text box where the format is displayed.

To do this, select your date column, go to Column tools, click on the Format dropdown, select Custom, and then reference specific format codes. Here are a few common ones:

• dddd: Displays the full name of the day (e.g., Tuesday).
• ddd: Shows the abbreviated day name (e.g., Tue).
• dd: A two-digit day of the month (e.g., 05).
• d: The day of the month without a leading zero (e.g., 5).
• MMMM: The full name of the month (e.g., March).
• MMM: The abbreviated month name (e.g., Mar).
• MM: A two-digit month number (e.g., 03).
• yyyy: A four-digit year (e.g., 2024).
• yy: A two-digit year (e.g., 24).

You can mix and match these codes. For example, typing "ddd, d MMM yyyy" into the format box would display dates as "Tue, 5 Mar 2024."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Create a Custom Formatting Column with DAX

What if you only want to change the date format for one specific slicer, but leave the original formatting intact for other visuals, charts, or calculations? Maybe you want a very specific structure like "Q1 2024" that isn't just a standard date. In these cases, your best bet is to use Data Analysis Expressions (DAX) to create a new, specially formatted column.

This method gives you pinpoint control, allowing you to create a text version of your date in any format imaginable while preserving the original date column for other calculations that require a proper date data type. The key here is the FORMAT function in DAX.

Step-by-Step Guide:

1. Make sure you are in the Report view or Data view.
2. In the top ribbon, navigate to the Table tools tab and click on the New column button.
3. The formula bar will appear. Here, you'll write a simple DAX formula using the FORMAT function. The syntax is: NewColumnName = FORMAT(<ColumnName>, "<FormatString>") For example, let's say we want to create a column for a slicer that shows the month and year. We would write: Slicer Month Fmt = FORMAT('Sales'[OrderDate], "MMMM yyyy") This formula takes the value from each row in the 'OrderDate' column and converts it into a text string like "March 2024."
4. Press Enter to create the column. Your table will now have a new column with the formatted dates.
5. Finally, go to your slicer visual on the report canvas. Drag this new column ('Slicer Month Fmt' in our case) into the 'Field' well of the slicer, replacing the original date field.

Your slicer will now display the dates using the custom format you defined with DAX.

Important Consideration: Sorting Issues

There's one crucial catch with Method 2: the new column you create using FORMAT is a text column, not a date column. This difference is significant because text columns sort alphabetically, not chronologically. If you're not careful, your slicer will list the months in alphabetical order (April, August, December, February...) instead of chronological order (January, February, March...).

How to Fix Slicer Sorting

Thankfully, the fix is easy. You can tell Power BI to sort your new text column based on a different, properly chronological column.

1. Select your new formatted text column in the Data pane (e.g., 'Slicer Month Fmt').
2. Go to the Column tools tab in the ribbon.
3. Click the Sort by Column button.
4. From the dropdown list that appears, choose your original date column (e.g., 'Sales'[OrderDate]).

Power BI will now use the original 'OrderDate' column to sort the 'Slicer Month Fmt' column behind the scenes. Your slicer will magically display the months in the correct chronological order while still showing your custom text format.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Which Method Should You Use?

Your choice depends entirely on your goal:

• Use Method 1 (Column Formatting) when you want a single, consistent date format applied across your entire report. It's the simplest and most efficient solution for establishing a uniform look and feel.
• Use Method 2 (DAX Column) when you need specialized formats, want to use different date formats for the same date in different visuals, or need categories like "Q1 2024". It provides maximum flexibility but requires the extra step of setting the sort order.

Troubleshooting and Best Practices

Even with these straightforward steps, you might run into a few common issues. Here’s what to look out for:

• My Slicer Didn’t Update! If your format doesn’t change, the most common reason is that the slicer is still using the old column. Double-check that you have dragged the correct (and newly formatted) column into the 'Field' well on the 'Visualizations' pane.
• The Type of Slicer Makes a Difference. Keep in mind that date formatting applies most visibly to List and Dropdown slicer types. If you’re using the default Between slider, the appearance in the boxes might reflect your system’s regional short date settings. However, the formatting updates should still apply.
• Always Use a Date Table. A golden rule in Power BI data modeling is to use a dedicated calendar or date table. This centralizes all your date-related logic. When you apply formatting to the date column in your calendar table, every single visual in your report that uses it - slicers included - will inherit the same consistent setup.

Final Thoughts

Updating the date format in a Power BI slicer is an essential skill for creating intuitive and professional-quality reports. For a quick report-wide update, adjusting the format in Column tools works perfectly. For bespoke formatting or more complex situations, creating a new DAX column offers unparalleled flexibility, as long as you remember to set the sort order.

Moments in analytics that should be simple, like formatting a date, often become frustrating time-sinks. We've built Graphed because we believe your time is better spent on strategy than on tweaking visuals. Stop getting bogged down in the manual setup of reporting tools. With our platform, you simply connect your data and describe the dashboards you need using natural language. We then build the dashboards for you, intelligently formatted and ready in seconds, so you can move straight to getting the insights that matter.