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 dates.
Thanks for help in advance
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.
6 Replies
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
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.
Anonymous Please select the "Field Value" in the Format Style drop down then select the measure.