Conditional Formatting: Highlight Date In Past

[HenryJS]

Hi all,

I would like to highlight cells where the 'Available' date is in the past below. 

How do I do this with conditional formatting?

1. Report

2. Data

Thanks,

Henry

[amitchandak · Accepted solution]

Create a measure like

Color Date = if(FIRSTNONBLANK('Table'[Available],TODAY()) <today(),"lightgreen","red")

You can use white in else.

In the visualization pane -> Format -> Conditional formatting -> Backgound (Switch On) -> Advance option

Choose format by field value and choose this measure

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Hi

All you need to do is create a flag that checks if a date is in the past or not, and then use that for your conditional formatting.

Create a measure like 

Today = TODAY()

This measure will return todays date. Then in your data create a calculated column like

Today Flag = IF([Available] < [Today], 1, 0)

This will generate a column that will return a 1 for dates in the past, and 0 for dates that are either today or in the future.

Then you simply apply conditional formatting in your table, using the sum of "Today Flag" to colour any date that = 1

If you need anymore help please let me know, otherwise please select this as your answer!

Good luck!

[SPD_52]

Excellent ! Just what I was looking for. Thank you very much.