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").
-
Many Thanks GuysGrowthNatives rohit1991 Shahid12523
Well I'm exactly where rohit1991 mentions.
Just that it always depends on users browser language.
Shahid12523 Yeah but I want the slider between slicer. If we use format we lose the slider between
Hi sanjeewauom,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to rohit1991 , Shahid12523, GrowthNatives for those inputs on this thread.
You are right, the “between” slider slicer always takes the browser language when the column is a date type. So even if the model is set to English (UK), anyone with browser in English (US) will still see mm/dd/yyyy.
If we use FORMAT() to force dd/MM/yyyy, then it becomes text and the slider option will not work only list or dropdown will be possible.
So as of now there is no direct way to keep the slider and fix the format for all users. The only options are either users keep browser in English (UK), or try some custom slicer visuals from AppSource.
Hope it helps you.
Regards,
Harshitha.
Thanks v-hjannapu
Yes.
I will check what custom slicers are available.
If you know any such slicer from AppSource please mention.
Thanks