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...
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.

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.