Forum Discussion
Conditional Format Overdue Date Based on Today
Good Evening-
I am stuck on Conditionally formatting an overdue date. If the date shown in the table is in the past from today's date, how do I write the DAX to highlight the background color red? Also, what steps do I take to apply the conditional format? My start date in the table is formatted as a date/time. The dataset will also be refreshed daily so I want to make sure this will stay a conditional format as the current date changes. Thank you!
Hi,
You can create a measure like this:DateFormatMeasure = IF(MAX(DateFormat[Date])>TODAY(),1,0)
Then go here:
And create a rule like this:
End result:I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
2 Replies
Hi,
You can create a measure like this:DateFormatMeasure = IF(MAX(DateFormat[Date])>TODAY(),1,0)
Then go here:
And create a rule like this:
End result:I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/