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.
Hi
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.
Solved! Go to Solution.
You can create a measure like this
Colour_Date =
VAR date_diff = DATEDIFF(TODAY(), MAX('Table'[End_Date]), DAY)
RETURN
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
Thanks @reidnmorrison
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
You can create a measure like this
Colour_Date =
VAR date_diff = DATEDIFF(TODAY(), MAX('Table'[End_Date]), DAY)
RETURN
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
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |