Highlight or Show Only specific months

[Anonymous]

Hi, I have a request from my user, they'd like to see the sales in very specific months instead of the timeline for the past 13 months.

I'm currently using this measure as a viz level filter:

13Meses - Filtro = DATEDIFF(MIN(L_Mes[FechaCalc]),TODAY(), MONTH) 

This limits the amount of months shown in my graph to 12:

I'm also using that filter to change the color of the month I want to highlight to yellow



This is working as I intended, however, the user would like to see ONLY Current Month, Last December and Same Month Last Year instead of the 13 month timeline. 

How can I achieve what they want?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , A measure like this should help.

Assuming 13 months are selected

calculate([measure], filter(Date, eomonth(Date[Date],0) = eomonth(today(),0) || eomonth(Date[Date],0) = eomonth(today(),-1) || eomonth(Date[Date],0) = eomonth(today(),-12)))

[Anonymous]

Thanks!

That worked for the most part. Is there any way in which I could include last december in there?