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.

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 ðŸ˜Š