Date Slicer - Issue with Changing to European Format

[sanjeewauom]

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.

https://community.fabric.microsoft.com/t5/Service/Date-format-in-slicer-is-changing-to-mm-dd-yyyy-wh...

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.

[v-hjannapu]

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.

[v-hjannapu]

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.

[v-hjannapu]

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.

[danextian]

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.

[sanjeewauom]

Hi @danextian 

Thanks for the reply.

But it would lose the range slider property which is what I need.

[danextian]

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.

[sanjeewauom]

Many Thanks Guys@GrowthNatives  @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 

[v-hjannapu]

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.

[sanjeewauom]

Thanks @v-hjannapu 

Yes. 

I will check what custom slicers are available.

If you know any such slicer from AppSource please mention.

Thanks

[Shahid12523]

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.

[sanjeewauom]

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. 👋🙏

[GrowthNatives]

Hi @sanjeewauom ,
You can do this to get the optimal result:

1. 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).

2. 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:

1. The date format applied to the column in the data model (and whether it’s starred * or not).

2. The Power BI Service language setting.

3. 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]🚀 

[rohit1991 · Accepted solution]

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").