Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @webportal ,
You will need to check your regional settings. Does your region support , or a . as decimal separator.
Refer this blog
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)
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
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@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