Help with multiple conditional formatting please

[Pricey79]

Hello everyone. I was hoping someone could help please.

I have 4 columns in a table, each column is a separate field from the same query.

The columns as per the picture below, are QC Planned Start Date, Actual Start Date, Planned End Date and Actual End Date

How could I get it to show red or green depending on if the actual is before, or on the planned date please?

So for example:

Planned End is the 19th and Actual End is 21st, then red

Planned End is the 10th , Actual end 9th , then green

So two different formats, one for planned start and planned end, and one for actual start and actual end please.

Hope that makes sense.

Thank You in advance.

[HashamNiaz · Accepted solution]

Hi !

You can create a column using following DAX to calculate if Planned End Date >= Actual End Date, you can do similar for Start date as well.

Planned End Date High = IF(Table[QC Planned End Date] >= Table[QC Actual End Date], 1, 0)

Now you can use this field in conditional formating, go to Format -> Conditional Formatting -> Background color -> On;

Colors4

You can adjust the Red & Green color based on your requirement.

Regards,

Hasham

[HashamNiaz · Accepted solution]

Hi !

You can create a column using following DAX to calculate if Planned End Date >= Actual End Date, you can do similar for Start date as well.

Planned End Date High = IF(Table[QC Planned End Date] >= Table[QC Actual End Date], 1, 0)

Now you can use this field in conditional formating, go to Format -> Conditional Formatting -> Background color -> On;

Colors4

You can adjust the Red & Green color based on your requirement.

Regards,

Hasham

[Pricey79 · Accepted solution]

@HashamNiaz 

Works perfectly. Thank you so much