Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! 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.
Regards,
Hasham
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.
Regards,
Hasham
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |