Forum Discussion
How to setup color code for date value
Thank you first! I am tracking different milestone dates in a PBI table as below, instead of creating flag columns for each date, is there a simple way if the date is before today, then showing as ...
hello Anonymous
here is the table that might be closer to your table.
do you accept visual like this?
since this is matrix, or else using table visula will be look like this.
if you good with either of those two, the process is same as above (unpivot those date tables)
Thank you.
Hihi! 😊 You can create a simple measure like this:
Measure = IF(MAX('Table (2)'[Column3]) < TODAY(), 1, 0)
Then, apply conditional formatting to your date column, setting it to show green color based on the measure. You can refer to the example in the image for guidance. 🎨✅
Hope it helps