Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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 , 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)))
Thanks!
That worked for the most part. Is there any way in which I could include last december in there?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |