Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I need to use a space as thousand seperator in my format function:
In this example i used ',' as a seperator and everything is fine:
when I change the ',' with a ' ' (space) you see the formatted text is all messed up.
any idea?
Solved! Go to Solution.
@Anonymous , In case comma, it does it automatically
try
"### ### ###.##"
Hi @amitchandak ,
as you can see below, when the number > 1M , it doesn't show the seperator with your solution.
I was looking for a more generic or automatic way, but if there is no other solution I will have to do it this way ..
Thanks for your answers.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!