Thousand separator: dot instead of comma

[darrochomumu]

Hey everyone,

I feel like this question has been asked a few times, but I can't seem to make it work.

I'm quite new at Power Bi (Desktop), and I'm compiling stats for my organisation. I would like for the thousand separator to be a dot "." instead of a comma "," (e.g. 5.000 instead of 5,000). What I've done so far:

• Changed PowerBI's locale to the Netherlands and restarting, it still shows with a comma. 
  My windows is in English US, but I can't change it due to my organisation's use of English. 

Would anybody be familiar with this issue or know any potential solutions?

Thanks in advance!

[Uzi2019]

Hi  @darrochomumu 
You can try below calculation

Format for millions of number

m1 = FORMAT([Measure],"#,,.0M","fr-fr") // replace the dot with a comma
OR
m2 = FORMAT([Measure],"#,,.0M","us-EN") // replace the comma with a dot

[Uzi2019]

Hi @darrochomumu 

 If you use the regional setting of a European country then it should work

https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

You can refer different  numbers format option from below link:
https://learn.microsoft.com/en-us/dax/format-function-dax

[amitchandak]

@darrochomumu , can check that on the new file. Sometimes old file do not take that

Also, make sure the language is setup correctly

https://community.fabric.microsoft.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/m-p/19492...

refer

https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/244