Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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?

4 REPLIES 4
Anonymous
Not applicable

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.## \$

Anonymous
Not applicable

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...

Anonymous
Not applicable

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.

vstephenmsft_0-1636969166516.png

 

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
Community Champion
Community Champion

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 )

 

 

result.PNG

 

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.