Forum Discussion
Post ProdigyDate format localization inconsistent on service
Post ProdigyGilbertQ 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:
Hi sanimesa ,
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 for the browser. You can refer following documentation:
https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions
Best Regards
Rena
- sanimesa
Anonymous 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.
Let me know what you need to look at this issue.
Hi sanimesa ,
Can I know how did you set the data type for these plain date formatted fields in Power BI Desktop and browser? Could you please provide the related screenshot of these plain date formatted fields with sample data and display format? Thank you.
Best Regards
Rena
- sanimesa
Anonymous Here are some screenshots. I have a simple SQL server table with a date field. All me sql server, desktop etc. settings are default US English
Here is what I did:
1. Set my browser setting to UK English.
2. First, format the date on desktop with the date-time format and published.
Result: date fields correctly displated as DD/MM/YYYY
3. Formatted the same date field as a date format.
Result: the date is not taking the browser localization.
Let me know if you need more information.
Incorrect resultCorrect ResultMy settings - set browser to UK to simulate UK user