How Do I Conditional Format a Date to go Red if before Today's date?
Here is my sample data - If End Date is before Today, i want it to go Red.
Go to Solution.
You can create a measure like this
VAR date_diff = DATEDIFF(TODAY(), MAX('Table'[End_Date]), DAY)
IF (date_diff < 0, "#C81517")
and then apply it as a conditional format to the column. The "#C81517" is HEX code so can be changed to a different red if you want
Post edited to correct table reference in the measure
View solution in original post
How do I turn my End Date into a measure? At the minute it is just a field within a table and i can't bring it into the formula like you have done above
That should be a column reference not a Measure, I misread the column name. If you replace [End Date] with 'Table'[End_Date] that will do the trick. I'll edit the other reply to show that
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.