Forum Discussion

arun2001mjl's avatar
arun2001mjl
Icon for Helper II rankHelper II
3 years ago
Solved

Coloring a Table based on Completion of Date Column

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?

 

 

Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

1 Reply

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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.