Conditional Formatting of Measures in Slicers

[Madhura29]

Hello Everyone !

Please help me solve the following doubt - 

I have few measures which are selected through Slicer. Is there any way where I can do a conditional formatting of Values ?

For Example if I have a measure - 1. Average, then the formatting should be Values below -1 - Red , Values 0 - Orange, Values above 1 - Green 

and second measure 2. Percentage - below 9% - Red 10% - Orange Above 11% should be Green. 

Thank you. 

[v-henryk-mstf]

Hi @Madhura29 ,

I did a test, the reference is as follows:

colour = 
var col = SELECTEDVALUE('Table'[Avg])
return
SWITCH(
    true(),
    col >0 ,"green",
    col = 0,"orange",
    col <0 ,"red")

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Madhura29 , You have create a color measure like this measure

Assume you measure is value
Switch(selectedvalue(slicer[measure]),
"Average", Switch( True(), [Value] =1 , "Red", "Green") ,
"Percentage ", Switch( True(), [Value] <=.9 , "Red",[Value] <=.1 , "Orange", "Green")
)

and use that in conditional formatting using field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4