cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Sean-OReilly
Helper IV
Helper IV

How Do I Conditional Format a Date to go Red if before Today's date?

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.

SeanOReilly_0-1675268038501.png

 

1 ACCEPTED SOLUTION
reidnmorrison
Resolver II
Resolver II

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

reidnmorrison_0-1675268940890.png

Post edited to correct table reference in the measure 

 

View solution in original post

4 REPLIES 4
Sean-OReilly
Helper IV
Helper IV

thanks @reidnmorrison 

Sean-OReilly
Helper IV
Helper IV

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

reidnmorrison
Resolver II
Resolver II

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

reidnmorrison_0-1675268940890.png

Post edited to correct table reference in the measure 

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors