Using comma , instead of dot in Numbers

[asgharkhan]

Hi members,

I need to show the output of my measure SUM('tbl'[Document Amount])

as $220,074,08 instead $220,074.08.
That is to use , for digit grouping and also for decimal point.

Thanks in advance.

[johnyip]

@asgharkhan 
A simple worksaround can be something like this:

Measure = 
VAR A= 12311.456
RETURN
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FORMAT(A,"#,##0.#################"),".","+"),",","."),"+",",")

But this will make PowerBI recognize this as text instead of numbers.

So this measure should be used at reporting level only. Whenever there are intermediate calculations, you should not do the above. The above should be applied to the measures that calculate the final results.

[Idrissshatila]

@asgharkhan ,

but this would change your output and give false numbers, so you're saying you want the value to be 22 million instead of 220 thousand.

[asgharkhan]

Thank you for the reply, no i want to format numbers with only comma for both as sperator and decimal point.

In pbix file already seleted Ducth(Neterlands) as Locale for Regional settings; and also in Region settings of Windows 11 as shown in screeshot, but it still shows . for digit grouping.

[asgharkhan]

Anyone please?

[Anonymous]

Hi @asgharkhan 

You can refer to the following example

Sample data 

Create a measure

Measure = var a=FORMAT(sum('Table'[Column1]),"")
return FORMAT(VALUE(LEFT(a,SEARCH(".",a,,BLANK())-1)),"#,##0")&","&FORMAT(INT(RIGHT(a,LEN(a)-SEARCH(".",a,,BLANK()))),"#,##0")

Output

Tip: the measure type is a text, so it can only be used as a value in table visual. 

Best Regards!

Yolo Zhu

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