How do I add a space as a thousand separator in power bi?

[Anonymous]

Hi,

I tried using regional setting but i didn't worked, my expectation is to change 123,456 to 123 456. Here comma seperator is replaced by space. Can someone suggest how it can be done?

[splambo]

For currency, try this:

Credit to @Greg_Deckler for providing the solution ### 000 000.00 \$

See the original answer: https://community.powerbi.com/t5/Desktop/How-to-format-data-numbers-to-Canadian-French-currency-form...

If you don't want the zeros to appear after the decimal, use ### 000 000.## \$

[splambo]

If you are looking to display data in your report in the French format (good for all places where French is an offical language, not just France ;), the following formatting code will output 687532 as 687 532. This code works all the way up to billions.

# ### ### ##0, $

-Select your column in the Data panel
-Column Tools tab

-Format field in the top ribbon

Thanks to Hein Kruger on https://community.dynamics.com/business/f/dynamics-365-business-central-forum/476492/ssrs-report-cha...

[v-stephen-msft]

Hi @Anonymous ,

You may try to use change type with local. Please refer to https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

You can try the following measure (caveat, the value is converted to text, so should only be used as the final display)

Separator =
VAR Leng =
    LEN ( [Sum Value] )
VAR Thous =
    LEFT ( [Sum Value], Leng - 3 )
VAR Rest =
    RIGHT ( [Sum Value], 3 )
RETURN
    IF ( [Sum Value] >= 1000, Thous & " " & Rest, Rest )