Inconsistent Date Format

[Echoy51]

Hi All,

I encounter a trouble with date format after publishing my report to the web. In my own desktop PowerBI, all dates are formatted to dd/mm/yyyy and all dates are shown correctly, similarly to the preview version.

However, after I published it to the website, my colleagues viewed inconsistent date formats as mm/dd/yyyy like below image:

What might cause this issue? How to make them view these dates formatting as dd/mm/yyyy?

Many thanks,

Echo

[shafiz_p · Accepted solution]

Hi @Echoy51 
This is due to differences in regional settings between your local environment and the web environment. You could try the below steps to fix this:

Firstly, ensure that the date format in your source data is set correctly. You can check this in the Power Query Editor in Power BI.

Check Power BI Service Settings:

• Open Power BI Service (app.powerbi.com) and go to Settings (top-right corner > gear icon).
• Ensure the Language setting is set to match your locale

Browser Language Setting:

Google Chrome

1. Click on the three dots (⋮) in the top-right corner of the browser.
2. Select Settings.
3. Scroll down and click on Languages.
4. Click on Add languages to add your preferred language.
5. Click on the three dots (⋮) next to your preferred language and select Display Google Chrome in this language.
6. Restart Chrome to apply the changes.
   
   

If this not solve your problem, use Dax Format Function to explicityly format date column to your desired format.

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

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Uzi2019 · Accepted solution]

Hi @Echoy51 

Check this blogs
https://community.fabric.microsoft.com/t5/Desktop/Date-format-changing-desktop-to-web/m-p/117204#M49...

https://community.fabric.microsoft.com/t5/Desktop/Date-Filter-Format-Changing-after-Publishing-the-r...

https://community.fabric.microsoft.com/t5/Desktop/Date-format-changed-when-published-to-PBI-Service/...

I hope this might help you.

I hope I answered your question!

[shafiz_p · Accepted solution]

Hi @Echoy51 
This is due to differences in regional settings between your local environment and the web environment. You could try the below steps to fix this:

Firstly, ensure that the date format in your source data is set correctly. You can check this in the Power Query Editor in Power BI.

Check Power BI Service Settings:

• Open Power BI Service (app.powerbi.com) and go to Settings (top-right corner > gear icon).
• Ensure the Language setting is set to match your locale

Browser Language Setting:

Google Chrome

1. Click on the three dots (⋮) in the top-right corner of the browser.
2. Select Settings.
3. Scroll down and click on Languages.
4. Click on Add languages to add your preferred language.
5. Click on the three dots (⋮) next to your preferred language and select Display Google Chrome in this language.
6. Restart Chrome to apply the changes.
   
   

If this not solve your problem, use Dax Format Function to explicityly format date column to your desired format.

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

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Echoy51]

Thank you. I changed other users' language setting and it worked!