Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.