How to turn off conditional formatting once the qualifier is met

[Anonymous]

Using conditional formattin, I set a flag to highlight the Patients Name and Visit Age fields 60 days PRIOR to their 19th birthdate. 

Is there a way to turn off the rule once the birthdate passes?

In the sample picture you will see the yellow highlights patients whose birthdays are within 60-days but the green highlights are people who have already turned 19. (In my report, both categories are actually yellow). Again, the goal is to create a rule that once the date of birth passes and the patient is 19, the field color will return to the white.

Here are the 3 new columns I used to create the conditional formatting alert

*19th-BD = DATE ( YEAR ( MERGE_BillingSUMMARY[Patient Birthdate] ) + 19, MONTH ( MERGE_BillingSUMMARY[Patient Birthdate] ), DAY ( MERGE_BillingSUMMARY[Patient Birthdate] ) )

*19th-BD Alert = ('MERGE_BillingSUMMARY'[*19th-BD] - 60)

*19th-AlertFlag = if (Now() >= 'MERGE_BillingSUMMARY'[*19th-BD Alert],1)

[amitchandak]

@Anonymous , you can create a measure based on you need and use that in conditional formatting using field value option

examples

olor Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) < date(2022,04,10) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)

Color Date =
var _min =minx(allselected(Date,Date[Year])
return
Switch( true(),
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
"red")

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

[Anonymous]

Sorry, I'm not an advanced user and though I appreciate the dax, could you also provide a bit of explanation as to what it all means and how the Green and Amber relate to my example?