Forum Discussion
Date Format differences between desktop and online
Hi,
I have some published report on power BI. The desktop app shows the date format in DD/MM/YYYY but when published the online versions show it in MM/DD/YYYY.
How can I correct this, I want both as DD/MM/YYYY?
Thanks
Chris
Hi chydewf1
What I did was to change the PC I was working on to use the English Format for the Region Settings as shown below.
And it is displaying fine in the Power BI Service, even with the Gateway refreshing the data.
- So I managed to get it to work. Once I signed in to chrome as a registered google user it allowed me to select english in the language setting and set it to default.
Thanks very much for the help
9 Replies
- AnonymousNot applicable
chydewf1,
This is a known issue in Power BI Service, the dates are displayed in MM/DD/YYYY format by default. There are ideas about this issue, please vote them up.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11698167-limitation-of-power-bi-online-compared-to-deskto
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837330-english-uk-and-english-us-options-for-powerbi
In addition, to work around this issue, in the Power BI settings set the Language to: “Default (browser language)” and ensure the browser is set to “English (United Kingdom)”
Regards,
Lydia - chydewf1Frequent Visitor
Hi Thanks for the replies
The fix works well in internet explorer but I cannot get it to work in Chrome.
Does anyone have any ideas?
Thanks
Chris
- AnonymousNot applicable
chydewf1,
I also can't get it work in Chrome. Since there is no existing option to change date format in Power BI Service, I am afraid that you need to use IE in this case.
Regards,
Lydia