Forum Discussion

Daniel_B's avatar
Daniel_B
Helper II
6 years ago
Solved

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

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 

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    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.

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    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. 

  • Daniel_B's avatar
    Daniel_B
    Helper II
    6 years ago

    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's avatar
      MFelix
      Super User
      6 years ago

      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.