Forum Discussion
Solved
Formatting numbers in a visual based on its value
Hi everyone, I'm using Treemap visual with two levels of data. For a clean report, I want to round the numbers. In Indian number system, 100,000 (hundred thousand) in international number sys...
When I answered this I found what I was looking for. I just had to remove the text and add the measure instead.
Amount = VAR YourValue = SUM('Tablename'[Value])RETURNSWITCH(TRUE(),YourValue >=100000, ROUND(YourValue,-3),ROUND(YourValue,-2))
I want the numbers within the visual to follow this formatting. Is there some way to use measures within a visual? I don't think is possible because measure with text added is text and not a number.
When I answered this I found what I was looking for. I just had to remove the text and add the measure instead.
Amount = VAR YourValue = SUM('Tablename'[Value])
RETURN
SWITCH(TRUE(),
YourValue >=100000, ROUND(YourValue,-3),
ROUND(YourValue,-2)
)