Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |