Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 @Anonymous
Thanks @Anonymous
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
85 | |
65 | |
51 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |