If condition with range

[Saritha077]

Hi All,
I am creating table with multiple fields i.e. dimensions and expressions
I want give conditional background color for measure, my measure is ratio

ratio values are like -5%,0%,3%,8%,10%.

my color condition is that like below : 

If(ratio < 3%, green(),

    If(ratio < 3% to 5% , yellow(),

          If(ratio > 5%, red()))

I am giving condition here

If i use above condition for color control it is not giving correct colors.

Please help me to get correct colors.

thanks in advance.

regards,

Saritha.

[sbaro_bd · Accepted solution]

Hello @Saritha077 ,

Modify your expression like this : 

If(ratio <= 0.03, green(),

    If(ratio <= 0.05, yellow(),

          If(ratio > 0.05, red()))

Regards.

[AshutoshBhumkar]

Hi Saritha,

Use below expression:

If(ratio <= 0.03, green(),

    If(ratio <= 0.05, yellow(),

          If(ratio > 0.05, red()))

OR use master measure and set colors for threshold for reusability.

Thanks,

Ashutosh