Forum Discussion

sprakash99's avatar
sprakash99
Frequent Visitor
4 years ago
Solved

Thousand separator for General Number

Hi, I have a column that displays the amount in 180+ currencies. I want to add a thousands comma seperator to it. Currently the value is a General Number. Whenever I try to add the comma seperator, ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI sprakash99,

    AFAIK, current you can't set multiple format rules in the same table numeric field.
    I'd like to suggest you write a measure formula with if statements and format functions to dynamically change the output string with different formats. (notice: when you use the format function, it will convert the result to text type)

    FORMAT function (DAX) - DAX | Microsoft Docs

    Regards,

    Xiaoxin Sheng

mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

Measure =  CONCATENATE('Table Name'[Column Name],",000")

sprakash99's avatar
sprakash99
Frequent Visitor
4 years ago

This will just add ",000" to my existing amount.
Ex: 563.76 will become 563.76,000

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    4 years ago

    Can you please explain the expected output

    • sprakash99's avatar
      sprakash99
      Frequent Visitor
      4 years ago

      The amount is currently 1234.56 for USD, 1234 for JPY , 1234.567 for KWD. Every currency has different decimal places. So, now I want to add comma separator to these.
      The existing powerBI thousands comma seperator supports only fixed decimal places. I don't want to have fixed decimal places and yet want to add commas to the values