Forum Discussion
Highlight or Show Only specific months
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!
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)))
2 Replies
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)))