March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
Solved! Go to Solution.
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
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
Thanks, Using the DAX has fixed it, I will use this method until PBI fixes the issue
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |