Forum Discussion

MM1001's avatar
MM1001
Frequent Visitor
1 year ago
Solved

Date values changing between Desktop and Browser

I have set up a report in PBI desktop using UK date format (DD/MM/YYYY) This shows fine as show below After I publish the report, all views of the report swap dates around In teams, in brows...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    In Power BI Desktop:

    Go to File > Options and settings > Options.
    In the Regional Settings section, set the Locale for this file to English (United Kingdom).
    Republish the report after changing this setting.

     

    Open Power BI Service (app.powerbi.com) and go to Settings (top-right corner > gear icon).

    Check the Language setting and ensure it’s set to match your locale.

    If nothing else works, explicitly format date columns using DAX:

    FormattedDate = FORMAT([DateColumn], "DD/MM/YYYY")

    If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

In Power BI Desktop:

Go to File > Options and settings > Options.
In the Regional Settings section, set the Locale for this file to English (United Kingdom).
Republish the report after changing this setting.

 

Open Power BI Service (app.powerbi.com) and go to Settings (top-right corner > gear icon).

Check the Language setting and ensure it’s set to match your locale.

If nothing else works, explicitly format date columns using DAX:

FormattedDate = FORMAT([DateColumn], "DD/MM/YYYY")

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

MM1001's avatar
MM1001
Frequent Visitor
1 year ago

Thanks, Using the DAX has fixed it, I will use this method until PBI fixes the issue