I have my report set up to switch between 2 different measures, how do I also switch the formatting?

[joebax86]

My report is set up so that all the visuals can switch between 2 different measures using a slicer, as one is a currency and the other not I also want the formatting to change as well. I've seen uses of calculation groups but I cant get tabular editor, additionally its being used in graphs so I can't just convert to text.  I gather that the new dynamic format feature may be able to help but not sure on the neccesary syntax. Below is how it currently works.

1. Built a table (Comparison scenario) as below for my 2 measure types.

2.Within this table using the following measure;

Selected Comparison = MIN('Comparison Scenario'[Comparison ID])

3. In my main data table using the following measure ;

Dynamic Time/Value(Sum) = SWITCH('Comparison Scenario'[Selected Comparison],

                     1, [Value (Sum)],

                     2, [Time (Sum)])

4. On my report, "Comparison" from the above table is used as a slicer and  the "Dynamic Time/Value (Sum)" is used as the value in my visuals.

How would I get £ as well as K/M etc depending on size of number for value and just the K etc for time.

Thanks in advance

[v-rzhou-msft · Accepted solution]

Hi @joebax86 ,

As far as I know, measure or columns in Power BI only support one data type.
So if you create a measure by SWITCH() it only support one data dype, it doesn't support dynamic data type based on your selection.

According to your statement, I think [Value (Sum)], [Time (Sum)]) are both measures. I suggest you to try Field in "What if Parameter".

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.