Mark Overdue Column (Date data type) with red

[zyniekies]

Hi team, 

I am referring to below link to achieve this functionality, however it did not work on me.

Solved: Power Bi Overdue date = mark red - Microsoft Fabric Community

This is my measure I created:

DateColor =
IF (
MAX ( 'EOP Input Main DB'[FA EOP (DD-Mmm-YY)] ) < TODAY(),
"#FF0000",
BLANK()
)

When I tried to use the measure, I got this instead at my conditional formatting opup.

The report:

Wold appreicate if someone could point out where did

[MohamedFowzan1 · Accepted solution]

Hi @zyniekies 

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

[Selva-Salimi · Accepted solution]

Hi @zyniekies ,

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.

[rohit1991 · Accepted solution]

Hi @zyniekies 

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.

[Selva-Salimi · Accepted solution]

Hi @zyniekies ,

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.

[MohamedFowzan1 · Accepted solution]

Hi @zyniekies 

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

[zyniekies]

Hi @MohamedFowzan1, @rohit1991 , @Selva-Salimi 

Thank you for pointing it out! It works now 😊