How to change the text color of value based on %. Im using % formatting to the measure valuel

[nishika]

How to change the text color of value based on %.

Im using % formatting to the measure value

Color should change based on below condition:

If value is  < 60% then Green

If value is > 60 % then Yellow

If value is > 85% then Blue

If value is > 100% then Red

[Rockstar7 · Accepted solution]

@nishika you can write text expression like below

if(value <0.6,green(),

if(value>0.6,yellow(),
if(value>0.85,blue(),
if(value>1,red())))