Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a measure with percetage format. So in card it gives a certain percentage value.
I want to apply conditional formatting where if < 2% "Green" and >2% "Red"but in Format Visual the options are greyed out. If I apply the below conditions it just make green for all values.
What is the correct method for it ? Please help
Solved! Go to Solution.
@Anonymous , if this % column then 2 means .02
< .02
You can also create a measure and use that in conditional formatting using field value option
Switch( True() ,
[percent] <.02, "Green",
"Red"
)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
If measure returning a Text then you will not be able to change the drop down values.
You need to return integer/decimal number datatype of your measure in order to see it.
Try not to format in Measure but instead using Formatting tab to select format of your measure.
Proud to be a Super User!
Hi,
Yes the format for my measure is "Percentage" but when i use IF or SWITCH statement it gives me text value "Red" or "Green"
Switch( True() ,
[percent] <.02, "Green",
"Red"
)
Use this measure as below in conditional formatting.
Proud to be a Super User!
@Anonymous , if this % column then 2 means .02
< .02
You can also create a measure and use that in conditional formatting using field value option
Switch( True() ,
[percent] <.02, "Green",
"Red"
)
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |