Conditional Formatting using a Column value

[Datagulf]

i want to do Conditional formatting based on a column value. My table is as follows

Person		Qualified
Andrew		Yes
Liz		No
Alex		Yes
Linda		No
Hellen		Yes
Angel		Yes

The task is to ensure that all that have not qualified are marked Red. Those that have not should be green. 

I have something as the following. Help to correct this.

Disqualified Color = IF(VALUE('Qualification[Qualified] = "TRUE", "Red", "Green"))

[Tahreem24 · Accepted solution]

@Datagulf  Follow the below steps:

Step 1: Create a calculated column using below DAX:

Color Column = If('Table'[Qualified]="Yes", "Green","Red")

Step 2: Go to Table and select any field on which you want this color formatting. Let's say Person column. And Choose Field value under Condition formatting and select Color Column (step1)

Step 3: You'll see color formatting as per rule applied

[Datagulf]

This is what I get @Tahreem24 

[Tahreem24]

@Datagulf , If you see my post so I haven't used MAX. Simply use column and follow those steps so you'll get just like my output screen shot.

[amitchandak]

@Datagulf , Try a measure like

Disqualified Color = IF(Max('Qualification'[Qualified]) = "Yes", "Red", "Green")

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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[Datagulf]

This is what I get @amitchandak