Forum Discussion
Inconsistent Date Format
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
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
- Click on the three dots (⋮) in the top-right corner of the browser.
- Select Settings.
- Scroll down and click on Languages.
- Click on Add languages to add your preferred language.
- Click on the three dots (⋮) next to your preferred language and select Display Google Chrome in this language.
- 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 HafizHi Echoy51
Check this blogs
https://community.fabric.microsoft.com/t5/Desktop/Date-format-changing-desktop-to-web/m-p/117204#M49447I hope this might help you.
I hope I answered your question!
3 Replies
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
- Click on the three dots (⋮) in the top-right corner of the browser.
- Select Settings.
- Scroll down and click on Languages.
- Click on Add languages to add your preferred language.
- Click on the three dots (⋮) next to your preferred language and select Display Google Chrome in this language.
- 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 HafizThank you. I changed other users' language setting and it worked!
Hi Echoy51
Check this blogs
https://community.fabric.microsoft.com/t5/Desktop/Date-format-changing-desktop-to-web/m-p/117204#M49447I hope this might help you.
I hope I answered your question!
