Change UK number format to Uruguay (Spanish) format

[Yolandaca]

Hi all!

I have created a visualization with data coming in Spanish numeric format (1.000,00). However, in Power BI, it is in UK number format (1,000.00).

I have followed the SQLBI method using Tabular Editor and changed the format there. Also, in Power query Editor, I have changed the country options.

Then I have tried to change the format in Power Query Editor to "Fix decimal Number" or "Decimal Number", and it is doing it in UK format.

Please can you help me to get the correct format number? 😔

Thanks in advance 🙂

[v-jayw-msft · Accepted solution]

Hi @Yolandaca ,

Here's a blog explains the Thousand Separator and Decimal Separator in detail , maybe you will get the solution from this article .

The article mentions changing the language in the system locale, so you can follow his steps to try it .

http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html

Best Regards,

Jay

[Yolandaca]

Thanks @v-jayw-msft 

That article is fantastic and well explained.

Kind regards,

Yolanda

[Greg_Deckler]

@Yolandaca This is typically based on your local language settings. File | Options and settings | Options | Regional settings (both Global and Current File). That said, you could use Custom Format Strings perhaps: Chelsie Eiden's Duration - Microsoft Power BI Community