Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 months ago
Solved

Mark Overdue Column (Date data type) with red

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

 

Need Help
Show and Tell
  • MohamedFowzan1's avatar
    MohamedFowzan1
    11 months ago

    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

  • Selva-Salimi's avatar
    Selva-Salimi
    11 months ago

    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.

  • rohit1991's avatar
    rohit1991
    11 months ago

    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.

     

     

     

4 Replies

  • MohamedFowzan1's avatar
    MohamedFowzan1
    Super User
    11 months ago

    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

  • Selva-Salimi's avatar
    Selva-Salimi
    Solution Sage
    11 months ago

    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.

  • rohit1991's avatar
    rohit1991
    Super User
    11 months ago

    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.