Forum Discussion
Solved
Unable to format a measure
I created a matrix table with the values are based on multiple measures. Because I needed to gather a group of measures under a title I had to encapsulate them under another measure as you see in...
You have 2 choices. You can use FORMAT([measure], "$0,000"). You can have a different format for each measure in your switch statement. Alternatively you can use a calculation group as I covered here https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/
note, the first solution is text formatted to look like a number, just so you know.
MattAllington
Community Champion
Community ChampionYou have 2 choices. You can use FORMAT([measure], "$0,000"). You can have a different format for each measure in your switch statement. Alternatively you can use a calculation group as I covered here https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/
note, the first solution is text formatted to look like a number, just so you know.