Forum Discussion
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 browser, everywhere! see below
Now what have I tried:
Adjusting data format in PBI destop settings
Adjusting the default language for, browsers, pbi service etc to be UK/default/match browser.
Adjusted MS teams language settings
Nothing seems to change it or keep it consistent?
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
3 Replies
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.
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 LinkedInThanks, Using the DAX has fixed it, I will use this method until PBI fixes the issue
