Forum Discussion

asgharkhan's avatar
asgharkhan
Frequent Visitor
2 years ago

Using comma , instead of dot in Numbers

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.

Need Help
Show and Tell

5 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    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's avatar
      asgharkhan
      Frequent Visitor
      2 years ago

      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.

       

       

       

  • johnyip's avatar
    johnyip
    Solution Sage
    2 years ago

    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.