change the Euro currency to Pesos from the Format "Currency" function.

[telesforo1969]

I have configured the currency as Euro somewhere, I need it in Pesos, I live in Mexico; the above causes me to present the thousands separators with a period, I need them with commas and the decimals with a period. I have already checked the Windows configuration and I have it correct, I have always had it for my country Mexico and comma separators for thousands.

[PhilipTreacy · Accepted solution]

@telesforo1969 

You can use this to format the string using comma as decimal separator and period as thousands separator

Measure = FORMAT(SELECTEDVALUE('DataTable'[Value]), "#,0.00" ,"de-DE")

NOTE that I used the locale string de-DE here rather than es-MX.  When I tried es-MX it still used period as decimal separator and comma for thousands separator.

Regards

Phil

[telesforo1969]

Thank you very much for your support. I think that the word "Optional" is important to omit in the description of the Format command [<locale_name>], "it should not be as optional in the Format command documentation". The literature says that PowerBi takes the Windows configuration and it is not true as I present it in the documentation. Please omit the word Optional and emphasize the list [<locale_name>].

[telesforo1969]

add more information