Multiple Colors for Conditional Formatting a Date Field

Hi , PowerBINoob24 

I think the dax is right.

Switch ( True() ,

isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) > today() , "orange" ,

max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red"

)

Please confirm that your conditions are:
(1) [Approved Date]=BLANK and [Due Date]Show "orange" > TODAY()
(2) [Approved Date]> [Due Date] when showing "red"

For the conditions you give, it is not explicitly stated that [Approved Date] = BLANK() and [Due Date]<=TODAY() and so on.

For your question, you can give us some detailed example data and corresponding output sample data in tabular form so that we can better help you.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Not sure why switching the lines made a difference, but now it works.

Switch ( True() ,

max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red",

isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) < today() , "orange"

)