Date format localization inconsistent on service

Question

I noticed that if I specify the date format as *3/14/2001 1:30:55 PM (General Date), it localizes correctly, for instance our UK users see the date as DD/MM/YYYY. However, specifying the date format as m/d/yyyy, it does not localize on UK user machines. Please see the attached image, the format in blue, when specified, correctly renders the date in UK locale. The format in red does not.

Is this expected behavior? What are the different options so that the date localizes correctly?

gilbertq · Answer

Hi thereWhat I have found is to make sure the localization is set both on the PC where you are creating the Power BI Desktop files.And that this matches when you are viewing the reports in the Power BI Service.I think you can also make the default localization settings within your browser options.

sanimesa · Answer

GilbertQ&nbsp;I do not believe that is the problem. Everything is same, but the same date field, when formatted as the first style format, correctly localizes on my UK user's browser but not when formatted as the second one. See the picture below:&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;sanimesa&nbsp;,Could you please try to update the date type of related date fields as "Using locale" in Power Query Editor?In addition, please check and set the proper language preference&nbsp;for the browser. You can refer following documentation:https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regionsBest RegardsRena

sanimesa · Answer

Anonymous&nbsp;This is not working as expected. When I set my browser language to English, UK, the date/time formatted dates correctly display in DD/MM/YYYY. However, the plain date formatted field, even when I set the locale to UK, is not displaying right.&nbsp;Let me know what you need to look at this issue.&nbsp;

anonymous · Answer

Hi&nbsp;sanimesa&nbsp;,Can I know how did you set the data type for these&nbsp;plain date formatted fields in Power BI Desktop and browser? Could you please provide the related&nbsp;screenshot of these plain date formatted fields with sample data and display format? Thank you.Best RegardsRena

Forum Discussion

Date format localization inconsistent on service

10 Replies

Related content

Possible Localization issue

Gallery Terms of Service

Local Refresh Incredibly slow, Service time regular

Power BI Refresh Needs Local Service – Any Workaround?

CI/CD inconsistency for Power Bi Reports