Fellow Power BI Users -
I have been working through the module for multi measure dynamics and have come across a problem. I have two slicers working from switch statements and have combined them. One selects dollars or units and the other selects viewing the outcome as a percentage or an actual value.
It is the second switch I am having trouble with - I can only format to see the result as either numbers OR % - I do not see how to say ‘in situation A show me the number, in situation B convert it into a %’
The statement I am using is:
Fcst vs Budget. = SWITCH( TRUE(), [Metric Selected 2] = "Actuals", [Fcst Vs Budget], [Metric Selected 2] = "%", [Fcst Vs Budget %], [Fcst Vs Budget] )
Is there a way to ensure that when % is selected the format is also %?