Forum Discussion
Different format in the same column
Hello.
I have a column that has numbers with and without decimals. I need it to display one decimal value ONLY when it is higher than 0. So, for example
1,236
4,521.5
864.1
156
At the moment, it is showing like:
1,236.0
4,521.5
864.1
156.0
Any idea which custom format can I use?
4 Replies
Anonymous ,
Try this setting for the mentioned column,
Anonymous , Can't change it further with Decimal Datatype.
You can create a calculated column with FORMAT() function but it will be a text column (not numeric)
Column = IF('Table'[Column] > 0, FORMAT('Table'[Column],"0.0"),FORMAT('Table'[Column],"0"))
