Mark Overdue Column (Date data type) with red

Hi Anonymous 

Above you are using Rules for Format Type but using DateColor.

Switch the "Format style" dropdown from "Rules" to "Field value" in conditional formatting. Then select your DateColor measure. Your DAX logic is correct

Hi Anonymous ,

in format stle, try to choose "field value".

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Hi Anonymous 

Could you please follow below steps:
1. I used the Sample Data table to solve the problem. You can change the table name to your own table name.

2. Create Measure:

DateColor =
IF (
    SELECTEDVALUE ( 'Table'[FA EOP (DD-Mmm-YY)] ) < TODAY(),
    "#FF0000",   -- red for overdue
    BLANK()      -- no color
)

3. Apply Conditional Formatting

• Go to your table/matrix visual.

• Column >> FA EOP (DD-Mmm-YY).

• Right click >> Go to Conditional formatting >> Background color.

• Choose:

  • Format by >>Field value

  • Based on field >> DateColor

• Apply >> OK.