Power Bi Overdue date = mark red

[Anonymous]

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 dates.

Thanks for help in advance

[Samarth_18 · Accepted solution]

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 · Accepted solution]

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

[Anonymous]

Hello @Samarth_18 

I have created a measure, but I am not able to use it in the condiction formating. 

Can you check it?

Thanks.

[Samarth_18]

@Anonymous Please select the "Field Value" in the Format Style drop down then select the measure.

[Anonymous]

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 · Accepted solution]

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

[Anonymous]

Thanks a lot @Samarth_18, this worked 😊