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
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!