Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.