topic Re: FORMAT function bug in DAX Commands and Tips

FORMAT function bug

Gintar12 — Fri, 29 Oct 2021 08:32:59 GMT

Hello,

When I use thousand separator in FORMAT function

FORMAT ( Number, "+#,##0.0%;-#,##0.0%" )

I get number with space separator instead of dot. How can I fix it?

If I don't use FORMAT function, everything is fine, separator is dot.

Any help would be appreciated 🙂

amitchandak — Fri, 29 Oct 2021 09:26:34 GMT

Gintar12 , do you country setting which uses decimal as , and thousand separator --> .

Seem like that has been forced on number

Try like

FORMAT ( Number, "+###.##0,0%;-###.##0,0%" )

Gintar12 — Fri, 29 Oct 2021 09:47:20 GMT

I have tried it. But it is not working. I got:

Gintar12 — Fri, 29 Oct 2021 09:52:52 GMT

I have fixed it! The problem was in my computer settings. Space was set as thousand separator. I changed it to a dot.