Forum Discussion

Gaddam's avatar
Gaddam
Frequent Visitor
3 years ago
Solved

Measure for Colour coding

Hello All,    I having problem with the colour changing, i am switch measure but is not working, always showing the values in  red colour TestPerc_CC = SWITCH(True(),[Test_Percentage]>50,"green",...
Need Help
TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
3 years ago

The measure as you wrote it works fine for me when I test it. Is your Test_Percentage a value between 0 and 100? Could perhaps be that Test_Percentage is a percentage between 0 and 1.00?

  • Gaddam's avatar
    Gaddam
    Frequent Visitor
    3 years ago

    Thanks for the time..yes the values are between 100% to 0%. For 100 it's showing red and 0 as well..

    • TomasAndersson's avatar
      TomasAndersson
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Try with decimals from 0 to 1 instead in your switch cases and see if it works.

      TestPerc_CC = SWITCH(True(),[Test_Percentage]>0.50,"green",[Test_Percentage]<0.50&&[Test_Percentage]>0.20,"orange", "red")