The locale settings don't seem to be working in the latest (June) update. I'm setting this to Portuguese (Brazil) and it isn't changing the thousands separator to a period as it should. Additionally, dates are not formatting as dd/mm/yyyy when using the global G format. The values are not formatting correctly with any visualization, in desktop or online. Is there another setting somewhere?

Hi jcapezzuto, I am not able to reproduce your issue. Could you please share sample data of your scenario and post the output in Power BI Desktop? Based on my test, after I change global regional setting to Portuguese (Brazil) in Power BI Desktop and import data from a sample text file, everything works as expected. For more details, you can check the following screenshots. From the above figures, you can note that Power BI Desktop interprets the value “100,002” as a decimal number using a Portuguese (Brazil) format, and the date value “2/3/2016” is interpreted as “3/2/2016” in Query Editor and “Wednesday, March,2016” in Data View. Furthermore, you can change the date formats to other existing formats in Data View, if you need to change it to DD/MM/YYYY format, you will need to use Format function.For more details about how Locale Setting works in Power BI Desktop, you can review this simialr blog: https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-query/ . Thanks, Lydia Zhang

Locale settings not working? | Microsoft Fabric Community

Forum Discussion

Related content

Possible Localization issue

Change Type locale not working in query editor for Date

TypeError: Cannot set properties of undefined (setting 'tableName')

Otimization settings In Desktop

Locale settings should not affect CSV import