How to setup color code for date value

[PioneerZhu]

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 green font color?

Thanks again!

[PioneerZhu]

Thank you @Chew_WenJie and @Irwan I knew about create new measure, just I need to track lot of columns which are all date value(request date, approval date, start date, complete date, test date, accept date....), I just don't want to create so many measures for each one. 

[Irwan]

hello @PioneerZhu 

if you dont want to create multiple measure and multiple color assignment, i would unpivot all those date column and use matrix visual instead of table visual.

1. i assumed you have another column to differentiate those date such as ID

2. unpivot that table so you will have only one date column

3. plot into matrix visual

4. assign color measure to date column (from Cell Elements)

5. the rest is same as above.

Hope this will help.

Thank you.

[PioneerZhu]

Thank you thank you @Irwan and appreciate your time. I am with you on the logic. Just my raw data is already in this way as your picture and the "ID" is consisted with multi several columns as 2nd picture. 

[Irwan · Accepted solution]

hello @PioneerZhu 

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.

[Irwan]

hello @PioneerZhu 

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.

[Chew_WenJie]

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