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
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!