Measure for Colour coding

[Gaddam]

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",[Test_Percentage]<50&&[Test_Percentage]>20,"orange", "red")

Thanks in advance

Gaddam

[TomasAndersson]

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]

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

[TomasAndersson · Accepted solution]

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")