Forum Discussion
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",[Test_Percentage]<50&&[Test_Percentage]>20,"orange", "red")
Thanks in advance
Gaddam
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")
3 Replies
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?
Thanks for the time..yes the values are between 100% to 0%. For 100 it's showing red and 0 as well..
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")
