Conditional formatting using measure

[FranckGbadamass]

Hello all,

Please help !!!

I'm struggling with conditional formatting, I would like to add a background color on column HR3, HR6, HR9 and HR12 based on nb of loan.

If the nb of loan is <500 then HR3 and HR6 and HR9 and HR12 should have a background color else nothing should happen.

How I can do this in PowerBI?

Please note that all fields that you can see in the tab above are measures not fields from my data source.

Thanks in advanced for your precious help.

[amitchandak]

@FranckGbadamass , Create a color meausre like

Switch( True() ,

[No of loans]<500 && max(Table[column ])  in{"HR3","HR6","HR9","HR12"} , "Green",

// add other

"White"

)

You can use this in conditional formatting field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4