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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hawkeye159
Regular Visitor

Conditional formatting using two date columns

Hi all, I'm new here and quite new to Power BI, trying to learn as I go and using forums like this to pick up tips.

 

But I'm struggling to find a solution that matches my problem.

 

I have a table with two different target dates - a normal target date (Target Date) and an extended target date (EOT Date).  The EOT date won't always be populated but the Target Date will.  I'm wanting to add conditional formatting so that, if the target date has expired, it will show red, BUT, if the EOT date has not expired, it will still show green.

 

I've tried adding a measure to show the Target Date as red where the date has passed and green if not:

 

Measure - Over Target Date = IF(SELECTEDVALUE(DCAPPL[TARGET DATE])>TODAY(),1,0)
 
Then added conditional formatting:
 
hawkeye159_0-1718797828549.png

 

That seemed to work:

hawkeye159_1-1718798081922.png

(Note: I added the same conditional formatting to the Application No. data too).

 

But am I able to highlight the columns if the EOT date was still in time?  So in the below screenshot, the application highlighted has a target date that has expired but the EOT date is still within time.  I would like this row to be showing as Green as it is still within time.  Likewise, the two applications below the highlighted one would show Red as their EOT date has expired.

 

hawkeye159_2-1718798353852.png

 

My apologies if this post is too lengthy or not concise enough.  I hope it makes sense and someone out there is able to understand me and help!

 

Many thanks in advance!

1 ACCEPTED SOLUTION
aduguid
Super User
Super User

Create a new calculated column or measure

 

Status = 
IF(
    ISBLANK('Table'[EOT Date]),
    IF('Table'[Target Date] < TODAY(), "Expired", "Not Expired"),
    IF('Table'[EOT Date] < TODAY(), "Expired", "Not Expired")
)

 

 

Set the rules for the conditional formatting:

  • If Status is "Expired", set the color to red.
  • If Status is "Not Expired", set the color to green.

View solution in original post

2 REPLIES 2
aduguid
Super User
Super User

Create a new calculated column or measure

 

Status = 
IF(
    ISBLANK('Table'[EOT Date]),
    IF('Table'[Target Date] < TODAY(), "Expired", "Not Expired"),
    IF('Table'[EOT Date] < TODAY(), "Expired", "Not Expired")
)

 

 

Set the rules for the conditional formatting:

  • If Status is "Expired", set the color to red.
  • If Status is "Not Expired", set the color to green.

Thank you so much, that works for me!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.