Forum Discussion
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 the below SS ( work around from this post )
However, it looks like the outcome is to have all measures with the same format. Which doesn't look good in my case because I want the 1st and 2nd measures to have a curreny format and the 3rd to be in %.
The goal is for the below measure values to be in $, I tried clicking on it, going to "Measure tools", clicking $, but it didn't work out.
Also tried to enclose it with Currency function in the measure code, but not output as well
Would appreciate any work around..
Thank you.
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.
1 Reply
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.