Forum Discussion
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...
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 Please try with removing .[Date] from the column name.
Samarth_18
Community Champion
Community ChampionHi 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
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.
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
Anonymous Please try with removing .[Date] from the column name.