Forum Discussion
Date Slicer - Issue with Changing to European Format
Hi sanjeewauom
The date format in Power BI slicers isn’t something you can fully control in one place. By default, it follows the report’s locale (set in Desktop) but in the Service it also looks at the user’s browser language. That’s why even after setting English (UK), anyone with their browser set to English (US) will still see mm/dd/yyyy.
There’s no direct way to force dd/mm/yyyy for everyone. Your options are:
-
Set the model locale to English (UK) in Desktop before publishing.
-
Ask users to switch their browser language (not ideal, but that’s how Microsoft designed it).
-
Use a custom slicer visual (like Hierarchy Slicer or Smart Filter) where you can explicitly set the date format.
-
Or, if you only need display (not slider), create a formatted text column with FORMAT(Date, "dd/MM/yyyy").
-
Hi sanjeewauom
When using the date slicer in range mode, the behavior is limited by the browser settings. However, if you switch to a dropdown or vertical list, you’ll have more flexibility by adjusting the data format.
You can see below that date in range slicer follows dd/mm/yyyy format which is what's set in my browser. However, the dropdown version has been custom formatted to MMM dd yyyy which Power BI respects.
The users will all have to change their browser settings. Calculated column using FORMAT converts the date to text disabling range slicer. Data format works on dropdown or vertical list slicer only.