Forum Discussion
Conditional Formatting for Percentage Value
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.
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.