Conditional Formatting for Percentage Value

[Anonymous]

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

[FarhanAhmed]

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.

[Anonymous]

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"
)

[FarhanAhmed]

Use this measure as below in conditional formatting.

[amitchandak · Accepted 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

[Anonymous]

hi @amitchandak ,

Got this now!! It is working. Thanks