Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Igotzepowerbi
Frequent Visitor

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  with conditional formatting but am getting very lost. Could someone help with how I can accomplish this? 

Igotzepowerbi_0-1692021615828.png

Thanks so much!! 🙂

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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
))
Ritaf1983_0-1692073037699.png

 

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

Result :

Ritaf1983_2-1692073207555.png

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

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
))
Ritaf1983_0-1692073037699.png

 

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

Result :

Ritaf1983_2-1692073207555.png

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.