Filter or selection

[miguelp06]

Hi all,

I have data from 8 years. Need to add 3 bottons (for example) for:

• Last 5 years
• Last 3 years
• Actual year

Anyone can help?

Thanks

Miguel

[PijushRoy · Accepted solution]

Hi @miguelp06 

Hope you have calender/datetable/year in your dataset.
You can implement 2 approach

Bookmark
Apply Year filter at Page level or visual level for 5 years, create a Bookmark
Apply Year filter at Page level or visual level for 3 years, create a Bookmark
Apply Year filter at Page level or visual level for 1 years, create a Bookmark
Create 3 button and assign the bookmark in Action

Tab
Create separate page for 5 years, 3 years, and current year
Create 3 buttons and assign the page navigation in Action

If solve your requirement, please mark the comment as SOLUTION

Thanks
Pijush

[Anonymous]

Hi @miguelp06 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[miguelp06]

@PijushRoy , thanks

I will try

[zenisekd · Accepted solution]

@miguelp06  I would also consider using "Relative date" style of the date slicer. You have to do few more clicks, but gives you more options and less work and administration.

Kudos and mark as solution appreciated 🙂

[miguelp06]

Thanks @zenisekd 

[PijushRoy · Accepted solution]

Hi @miguelp06 

Hope you have calender/datetable/year in your dataset.
You can implement 2 approach

Bookmark
Apply Year filter at Page level or visual level for 5 years, create a Bookmark
Apply Year filter at Page level or visual level for 3 years, create a Bookmark
Apply Year filter at Page level or visual level for 1 years, create a Bookmark
Create 3 button and assign the bookmark in Action

Tab
Create separate page for 5 years, 3 years, and current year
Create 3 buttons and assign the page navigation in Action

If solve your requirement, please mark the comment as SOLUTION

Thanks
Pijush