cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pricey79
Helper III
Helper III

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

Pricey79_0-1620913149186.png

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.

2 ACCEPTED SOLUTIONS
HashamNiaz
Super User
Super User

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;

 

Colors4Colors4

 

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

 

Regards,

Hasham

 

View solution in original post

@HashamNiaz 

 

Works perfectly. Thank you so much

View solution in original post

2 REPLIES 2
HashamNiaz
Super User
Super User

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;

 

Colors4Colors4

 

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

 

Regards,

Hasham

 

View solution in original post

@HashamNiaz 

 

Works perfectly. Thank you so much

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.