Forum Discussion
Inconsistent Date Format
- 1 year ago
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 Hafiz - 1 year ago
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!
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 Hafiz
Thank you. I changed other users' language setting and it worked!