Forum Discussion

Matt_W2022's avatar
Matt_W2022
Regular Visitor
3 years ago
Solved

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"  I have been able to create a measure that turns the date field red wh...
  • daXtreme's avatar
    daXtreme
    3 years ago
    [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
daXtreme's avatar
daXtreme
Solution Sage
3 years ago
[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