Forum Discussion
Conditional Formatting Past Due Date
I want to show font color (Red) if the Due Date is Today or before today.
Table name is TR_FSP_2 column is Date_Due.
| Case Name | Date_Due |
| Smith, j | 10/06/2020 |
| x, Greg | 11/07/2022 |
| Harris | 06/14/2023 |
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
10 Replies
There is a function called TODAY() that will return the curernt day (in UST time), which you can add (time zone offset / 24) to, depending on your timezone.
So you can create a measure like so:
FormatColour =var todayInYourTimeZone = TODAY + (timezoneOffset / 24)
return IF(todayInYourTimeZone >= [Date_due], "Red")
And use conditional formatting on your table to format the cells where the cell is overdue.
Hi,
TODAY is a function so needs parenthesis : TODAY()
To add to inglexjc answer, notice taht the TODAY() date is the one from the machine where the report is running, ie :
your PC when on Power BI Desktop
or the server on Power BI Service (and then it depends on the location of the server...).
You can check this location in Power BI admin.
Hope it helps
If you're running it on your PC or on a server within the same time zone as yours, TODAY() is fine and so you don't need that part, just TODAY().
Otherwise replace by a value (ie 7 if you're 7hrs ahead of US and your report will be published on a US Server)
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
