Relative date slicers and filters

You can now use relative date filtering in slicers and filters.

Relative dates in filters

Suppose that you want to show all of the sales made in the last 3 years.  You could start by applying relative date filtering to a date field:

Choose this option when applying a filter to enable relative date filtering.

You can then choose from these options:

You can show values which are in the last, next or current day, month or year.

Here's how to show items in the last 3 years, as an example, including today's figures:

You can type in the number of time periods to go forward or back.

Relative date filtering in slicers

The first thing to note is that to use relative date filtering in a slicer, you can't turn the slicer header off:

I normally turn this off and use a slicer title instead, but you can't do this if you want to use relative date filtering.

When viewing a slicer, you can click on this downward arrow:

You can click on this arrow in the slicer header to choose a different way to filter the data.

Choose the obvious option to use relative filtering:

Choose this option to use relative date filtering.

You can then choose the exact filter you want to apply:

Here we're showing data for the last 3 years, but lots of other combinations are possible!