DAX - Month Color -> past vs. Future

[Anonymous]

Hi Team,

I have 2021 year data and I have to show two different colour for Past and Future Month.

past months -> Jan to Jul = light colour

Future Months -> Sep to Dec = dark blue

Thanks,

KV's

[amitchandak · Accepted solution]

@Anonymous , You can try a color measure in conditional formating with field value option

Switch( True() ,

max(date[Date]) > eomonth(today(),0) , "dark blue" , // or use hex code with #

max(date[Date]) <= eomonth(today(),-1) , "blue" 

, "green"

)

You will not conditional formatting option with legends or multiple measures