Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Slicers

Hi Team,

 

I am trying to get a 'button style' single slicer which filters by Q1, Q2, Q3 and Q4.  I would like the output filter for each to display in a cumlative way so when the user clicks a Quarter the get the selection as follows:

Q1 = Q1

Q2 = Q1+ Q2

Q3 = Q1+ Q2 +Q3

Q4= Q1+ Q2 +Q3 + Q4

 

Really hope this makes sense.  If not feel free to ask any questions and I will try to clarify.

 

Thanks in advance for your help 🙂 

 

Need Help

3 Replies

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    There is one way to achieve this you have to first create 4 seperate buttons for Q1,Q2,Q3 & Q4. and then you have to create seperate bookmarks for showing and hiding slicers on specific selection. You have to add actions to button selected initially and add bookmarks to them which you want to display on click.

    Hope I have answered your Query!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you 🙂  I will give it a go and let you know how I get on. 🤞 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Managed to find a simpler way by creating a new quarterly 'link' table which did the trick.