topic Re: Conditional Formatting for blank date based on text from another field in DAX Commands and Tips

Conditional Formatting for blank date based on text from another field

Matt_W2022 — Fri, 11 Nov 2022 11:53:58 GMT

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 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.

Re: Conditional Formatting for blank date based on text from another field

daXtreme — Fri, 11 Nov 2022 12:07:08 GMT

[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

Re: Conditional Formatting for blank date based on text from another field

Matt_W2022 — Fri, 11 Nov 2022 12:50:09 GMT

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