Forum Discussion

sanjeewauom's avatar
sanjeewauom
Frequent Visitor
1 year ago
Solved

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. https://community.f...
Need Help
  • rohit1991's avatar
    rohit1991
    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").

GrowthNatives's avatar
GrowthNatives
Icon for Super User rankSuper User
1 year ago

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