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.
Go to 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;
You can adjust the Red & Green color based on your requirement.
View solution in original post
Works perfectly. Thank you so much
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.