How to create date range buttons that select last 12 m, FYTD, last month

[willz06jw]

Hi and thanks for reading,

How can I create three single-click selectors (slicer?) that filter the date range on my report by last 12 months, current fiscal year to date and last month?

Thank you!

Will

[Anonymous · Accepted solution]

If you add a date field to a slicer, you can turn on relative date filtering after you add a field with dates to the slicer using the little arrow. You can choose to have it show the last 12 months based on today. You'd then add another slicer with the same date field and turn on relative date filtering again and then choose "Days" and put 30. As far as the fiscal year, that requires additional programming and there are a whole bunch of topics on that if you do a search.