Forum Discussion

Pricey79's avatar
Pricey79
Helper V
5 years ago
Solved

Help with multiple conditional formatting please

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.

Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    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

     

2 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    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