Forum Discussion
Date Slicer - Issue with Changing to European Format
- 1 year ago
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").
-
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.