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.
hello Anonymous
i am not sure how your table looks like, but it is possible.
here is a simple example i made.
1. create a new measure for defining color (you can change "Green" and using color code to match your preferences)
Color =
IF(
SELECTEDVALUE('Table'[Date])<TODAY(),
"Green"
)
2. assign conditional formating to date column or any desired column and choose conditional formating type (i.e font color)
3. choose Field in Format Style and select the measure made before.
Hope this will help.
Thank you.