topic Conditional Formatting (2 Rules for same column) in DAX Commands and Tips

Conditional Formatting (2 Rules for same column)

Userpath77 — Thu, 01 Jul 2021 15:01:54 GMT

Hello All

I have these two DAX measures. I basically need to color one column two different colors (Red if date in other column is within 45 days and Yellow if within 60 days. I will need the 45 day rule to have higher precedent so that it overrides the 60 day Yellow when the appropriate time comes.

Does anyone know how to nest these two statements together and give the 45 day higher precedent?

45_Day_Color = if(FIRSTNONBLANK(Elig_List[45_Day_Alert],TODAY()) <today(),"red","white")

60_Day_Color = if(FIRSTNONBLANK(Elig_List[60_Day_Alert],TODAY()) <today(),"yellow","white")

I appreciate any help!

Re: Conditional Formatting (2 Rules for same column)

Payeras_BI — Thu, 01 Jul 2021 15:50:34 GMT

Hi Userpath77 ,

I believe SWITCH would help here.

MEASURE = SWITCH( TRUE(), SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<45, "RED", SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<60, "YELLOW", "WHITE" )

Re: Conditional Formatting (2 Rules for same column)

Userpath77 — Thu, 01 Jul 2021 18:45:29 GMT

Thanks Payeras-----I had to adjust it a little, but worked perfect! Thanks again.