How to format an integer with DOT as a thousands separator

[webportal]

I've seen dozens of similar questions about this and read the entire documentation about FORMAT, but I still can't figure out how to format an integer with DOT as a thousands separator!

LIKE: 1.000

So simple and so complicated.

This is what I'v tried:

FORMAT([Measure], "#.000")

FORMAT([Measure], "##.###")

And lots and lots of other combinations.

[harshnathani]

Hi @webportal ,

You will need to check your regional settings. Does your region support , or a . as decimal separator.

Refer this blog

https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=50#:~:text=In%20United%20States%2C%20decimal%20s...

else you can view these solutions

https://community.powerbi.com/t5/Desktop/set-dot-as-decimal-separator/td-p/609657

https://community.powerbi.com/t5/Desktop/Format-Function-Decimal-Dot-or-Comma/td-p/594047

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button) 

[Anonymous]

Hi @webportal 

Convert the column to text and if you still see the "." then use the 

SUBSTITUTE([Product Code], ".", ",")

to convert "." to ","

Alternatively, what I would do is to conver to text and use the

SUBSTITUTE([Product Code], ".", "") to create a new c

and use the inbuilt comma seperate for thousands seperator in view

[amitchandak]

@webportal , I think that is regional number setting that will change it from "," to "."

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

Regional settings
https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visu...
https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...

post that use

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings