Date values changing between Desktop and Browser

[MM1001]

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?

[Kedar_Pande · Accepted 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

[MM1001]

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

[gaurav-lakhotia]

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.