Forum Discussion

Igotzepowerbi's avatar
Igotzepowerbi
Frequent Visitor
3 years ago
Solved

Conditional Formatting for color coding Date

Jolly Monday, I need to color code by the requested ship date. For example, if it is within next 5 days color code it yellow and if it is within 6-10 days, color it green. I am trying to do this  wi...
Need Help
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi Igotzepowerbi 

    You can achieve it with 2 steps :

    1. Create a dax for your condition, for example:

    Condition =
    IF(SELECTEDVALUE('ship dates'[Ship date])>today()+5 && SELECTEDVALUE('ship dates'[Ship date])<today()+10,1,
    IF(SELECTEDVALUE('ship dates'[Ship date])>today()+10,2
    ))

     

    2. choose the column that you want to format on your visual table and modify the format according to results of the Dax measure

    Result :

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi Igotzepowerbi 

You can achieve it with 2 steps :

1. Create a dax for your condition, for example:

Condition =
IF(SELECTEDVALUE('ship dates'[Ship date])>today()+5 && SELECTEDVALUE('ship dates'[Ship date])<today()+10,1,
IF(SELECTEDVALUE('ship dates'[Ship date])>today()+10,2
))

 

2. choose the column that you want to format on your visual table and modify the format according to results of the Dax measure

Result :

 

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