Last month, last week, last n days buttons filters

[tokhir]

This is the part of my table. I need manaully create buttons to filter this table by date. I need Last month, last week, and last n days(i will set number of days manually) buttons. 

[_AAndrade · Accepted solution]

Hi @tokhir,

I'm attaching a pbix file with my solution.
The final output was this:

[SamWiseOwl]

Hi @tokhir 

The easiest thing to do is add the Date column into the Filter pane.

Drag it into Filters on this Visual and change it from Basic filter to Relative date.

This lets you choose last 7 days or Week calendar.

You can also choose Last Month Calendar.

Then finally last x days.

Now go to the View tab and toggle on Bookmarks.

These let you save the page filtered in your 3 versions.

Add a bookmark for the week, month and x days filters.

Highlight the 3 in the bookmark pane and choose group.

Now go to the Insert tab choose Buttons | Navigation | Bookmark Navigator

In the Navigator Format go to Bookmarks and change it from All to the name of your group.

Remember to hold Ctrl when you left click to toggle the buttons.

Enjoy!