Forum Discussion

miguelp06's avatar
miguelp06
Frequent Visitor
2 years ago
Solved

Filter or selection

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

  • 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


  • 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 🙂

5 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    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


  • 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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.