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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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