Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I was wondering if there was a way to have a slicer to filter a graph to only show months which are after the selected month. For Example, if in the slicer I select Jan-24, it will show Jan-24, Feb-24 etc.
Thanks, @Ritaf1983 🙂
That tutorial is for when you want to select N month; in my case, it would be all months until the end of the financial year. I could still use it with N = 12 and add a filter to filter out months outside the FY, but I wondered if there was an easier way.
Hi @simonepalmas45
Yes, this is possible with Dax manipulations.
Please refer to the linked tutorials:
https://www.burningsuit.co.uk/blog/visualising-next-or-previous-n-months-selected-month
https://www.youtube.com/watch?v=JUUXGw86wUY
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |