Date time formats in the service are displayed as US datetime format mm/dd/yyyy where as the desktop is able to display the same datetime format as UK datatime format dd/mm/yyyy. The service that the report is displayed in is based in Western Europe.
See picture below which shows the same section of a report open in PBI service and PBI desktop
3 Comments
What is your data source here? You can try to add ?lanauge=en-GB in browser to force the language setting - app.powerbi.com?language=en-GB
Or change the browser language to English (United Kingdom).
Best Regards,
Herbert
Hi Herbert thanks for the suggestions. I tried amending the URL as you suggested by inserting the language setting you suggested, no difference :-( The language for the browser, IE v11, in this case, is set to English en-GB.
The last time l reported this to Microsoft l got a response acknowledging it and asking me to report as a bug. Recently Microsoft are asking for bugs relating it international settings. This does annoy my clients most of whom as expect UK date time format eg dd/mm/yyyy not USA eg mm/dd/yyyy. Microsoft have given this section where to report these bugs so hopefully l have found the right place :-)
Is you data source SSAS? In Power BI Service, do you select English for Power BI as below?
Best Regards,
Herbert
