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.
Hi @Madhura29 ,
I did a test, the reference is as follows:
var col = SELECTEDVALUE('Table'[Avg])
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.
@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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.