Forum Discussion
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...
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
Hi MM1001 , this seems to be a bug from Power BI Desktop latest release. I have seen a few more tickets in community where people raised wired behavior of Power BI. I suggest installing an earlier stable version.