Thousand separator for General Number

[sprakash99]

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, from the Measure Tools tab, it automatically changes the format to decimal number. But for different currencies, the number of decimal places needed is different. 
Ex: JPY has 0 decimal places but KWD has 3 decimal places. 

How can I add commas to the amount without rounding up or down the number and not using fixed decimal places?

Thank you!

[Anonymous · Accepted solution]

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]

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

[sprakash99]

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

[mh2587]

Can you please explain the expected output

[sprakash99]

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