Exclude future month&year on conditional formatting

[ronaldbalza2023]

Hi, hope everyone is having an awesome day. I would like to know how to exclude future months and years when applying conditional formatting to a matrix visual.

Does anyone know how to do this in Power BI? Any help or guidance would be greatly appreciated!

Thank you in advance.

[amitchandak · Accepted solution]

@ronaldbalza2023 , Based on your measure,

a new measure like this should

if(max(Date[Date]) > eomonth(today(),0) , [Measure], blank()) 

Do not color the blank value