Forum Discussion
Date Slicer - Issue with Changing to European Format
Hi All,
I have a date slicer with a slider set to between. It is in US format (mm/dd/yyyy).
My client want it in European format. (dd/mm/yyyy).
I tried this solution.
But this seems to be bounded by language settings.
Need to set to ENG UK in Power BI Desktop and service.
But the most annoying thing after all that is it still depends on users browser language and I don't know why they have their browser language as ENG US.
Can you help to fix this without having to ask users to change their browser language.
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").
-
13 Replies
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 ,
You can do this to get the optimal result:- Fix the field’s format (avoid the “*” formats)
- In Model view (or Data view), select your Date column.
- In Column tools > Format, pick a format without the star (e.g., dd/MM/yyyy — no *).
- Ensure Data type = Date (not Date/Time unless you actually need time).
Confirm Power BI Service language:
In the Service, go to Settings (gear) > General > Language.
Set Display language = English (United Kingdom) (or “Use browser default” if your browser is already EN-UK).
- If your source parsing is UK-style and ever shows wrong dates in Desktop
Refered From: \-UK-date-format-dd-mm-yyyy-in-Date-slice
Optional but handy
If you must show a text label somewhere (card/table) in a specific style, you can use:
Date UK Label = FORMAT ( 'Calendar'[Date], "dd/MM/yyyy" )
Important Note:
What you’ve set in Windows Regional Settings (English UK, dd/MM/yyyy) only affects how Power BI Desktop interprets and displays dates on your machine. Once you publish to the Power BI Service, the slicer doesn’t look at your PC’s regional settings anymore — it relies on:
The date format applied to the column in the data model (and whether it’s starred * or not).
The Power BI Service language setting.
The browser’s preferred language (if the column format is locale-aware).
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! [Explore More]🚀- Fix the field’s format (avoid the “*” formats)
To force dd/mm/yyyy format in a slicer without relying on browser language, use a formatted text column like:
EuropeanDate = FORMAT('Date'[Date], "dd/mm/yyyy")
Then switch the slicer to dropdown or list mode (not slider). This bypasses locale issues completely.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
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.
Hi GrowthNatives and rohit1991
Many thanks for the prompt responses from you both.Well I'm excatly where Rohit is mentioning. That all depends on users browser language.
The thing is I cannot ask each and everyone to change their browser settings.
But Thanks again for kind replies. 👋🙏
Hi sanjeewauom,
I would also take a moment to thank danextian , for actively participating in the community forum and for the solutions you Have been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Harshitha.Hi sanjeewauom,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.Hi sanjeewauom,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.
