SWITCH for 2 parameters (possibly 3 with a blank statement)

[Daniel_B]

Hi There

I've created a measure which shows an up arrow if the current month is greater than the previous month however I would like to add a down arrow if it is lower than the previous month and if there is no data or the values are the same just a line (I have the Unichar codes available to hand)

Here is my code so far 

Difference = 
SWITCH(TRUE(),[%Extreme]<'Sample Data'[%Extreme LM],
UNICHAR(9660), BLANK())

Any help would be greatly appreciated

Thanks

Dan 

[Daniel_B]

Okay so I've solved this challenge now but I would like to know if I've used the below measure for a scorecard to get the trend arrow, is there a way of making it change color depending on the UNICHAR code I'm using for the arrow based on the results (see code below) - as I'm using a scorecard I know I can't use conditional formatting on the value 

%Difference Arrow = IF([%Extreme]>[%Extreme LM],UNICHAR(9650),IF([%Extreme]<[%Extreme LM],UNICHAR(9660),UNICHAR(9644)))

Arrow up = RED

Arrow down = GREEN

Line = Yellow

[MFelix · Accepted solution]

Hi @Daniel_B ,

if you replace the unichar codes by the colours you want then use that measure as your condittional formatting should work on the color of the arrows as needed.

[MFelix]

Hi @Daniel_B ,

You need to use a similar measure to this one:

Difference =
SWITCH (
    TRUE (),
    [%Extreme] < 'Sample Data'[%Extreme LM]
        || [Measure] = BLANK (), UNICHAR ( 9660 ),
    [%Extreme] = 'Sample Data'[%Extreme LM], UNICHAR ( 9999 ),
    BLANK ()
)

Replace the codes for unichar and the measure for the ones that adjust to your model.