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
Matt_W2022
Regular Visitor

Conditional Formatting for blank date based on text from another field

Hi Everyone, 

 

I am trying to highlight the date column red when the date is blank and the status field is "Completed" 

Capture.PNG

I have been able to create a measure that turns the date field red when status is completed, how do i make this only happen when the date is blank?

 

Color Date MPLA =
VAR Name1 = IF(SELECTEDVALUE('PLP & MPLA Qualification Data'[MPLA Status]) = "Completed", True, False)
RETURN
SWITCH(
TRUE(),
Name1 , "RED")
 
Thanks in advance for any advice.

 

1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

[Color Date MPLA] =
var StatusValue = 
    SELECTEDVALUE( 'PLP & MPLA Qualification Data'[MPLA Status] )
var DateValue_ =
    SELECTEDVALUE(
        'PLP & MPLA Qualification Data'[MPLA Date],
        // This value makes sure that when many dates are
        // visible in the current context BLANK is not
        // returned as that could change the logic.
        dt"3000-01-01" 
    )
var ColorCondition = 
    StatusValue = "Completed" && ISBLANK( DateValue_ )
VAR Color =
    IF( ColorCondition, "red" )
return
    Color

View solution in original post

2 REPLIES 2
Matt_W2022
Regular Visitor

That has worked a dream, thank you for your help @daXtreme 

daXtreme
Solution Sage
Solution Sage

[Color Date MPLA] =
var StatusValue = 
    SELECTEDVALUE( 'PLP & MPLA Qualification Data'[MPLA Status] )
var DateValue_ =
    SELECTEDVALUE(
        'PLP & MPLA Qualification Data'[MPLA Date],
        // This value makes sure that when many dates are
        // visible in the current context BLANK is not
        // returned as that could change the logic.
        dt"3000-01-01" 
    )
var ColorCondition = 
    StatusValue = "Completed" && ISBLANK( DateValue_ )
VAR Color =
    IF( ColorCondition, "red" )
return
    Color

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.