Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Bi Overdue date = mark red

Hello,   I would like to ask for help with marking overdue date red in power bi table.    When I try to do conditional formatting on the date, it is offering me only count or count(dist) of the d...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    You could create a measure as below and use it in conditional formatting.

     

    Conditional_formatting = if(max(table[your_date_column) < Today(),"red")

     

    BR,

    Samarth

  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Anonymous Please try with removing .[Date]  from the column name.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Samarth_18 

 

It is behaving very weird

It gave me a total in the table but not changed the color of the overdue date...

Can you please check it?

Thanks.

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Anonymous Please try with removing .[Date]  from the column name.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks a lot Samarth_18, this worked ğŸ˜Š