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",...
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")
TomasAndersson
Solution Sage
Solution SageThe 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..
- TomasAndersson
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")
