I want to build a slicer that can filter months for me in any years.
What I want to do is, I want to create a button or slicer with one click it can filter for me the months.
This month - Aug 2021
So with one button on the slicer will filter for me Jan - Aug month only. So that I can see all the Jan - Aug sales in 2021, 2020, 2019, 2018 … etc
Next month - Sep 2021
So the slicer will filter for me Jan - Sep month only. I can see the all the sales from Jan - Sep in 2021, 2020, 2019, … etc.
Do we have any kind of way to do that?