Coloring a Table based on Completion of Date Column

[arun2001mjl]

Hello All,

Need Help.

I have a Table with Company Holiday List for all Employees.

I need to color the column whichever is already completed. Future dates need to be in Different color and Completed Dates to be in different color. Is it possible in PowerBI?

[v-yadongf-msft · Accepted solution]

Hi @arun2001mjl ,

This is my test table:

Create a measure:

Measure = IF(MAX('Table'[Date])<= TODAY(),"Lightpink","Lightskyblue")

Create a table and right click, select "Conditional formatting" - "Background color".

Conditional formatting for every column:

You will get a table like this:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.