Forum Discussion
Conditional Formatting for Percentage Value
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
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
5 Replies
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-66e0afcb15f3hi amitchandak ,
Got this now!! It is working. Thanks
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.
Use this measure as below in conditional formatting.
