0

Hide or Unhide Slicers

Hi,

Does anyone know of a way dynamically hide/ unhide slicers. I have a report where a user has multiple optional slicers e.g SKU Code, Barcode, Secondary SKU Code or Product Description. I would like to show 1 slicer instead of all 4, and thought I could reduce this by having 1 other slicer that has request type. Any thoughts or an alterative approach?

Thanks,

Linda

4 replies

null
    • Ove_Sandau
    • 3 days ago
    • Reported - view

    Hi 

    Could you use minitabs? I've just had a little play and you can put a slicer on each tab. 

    Regards

    Ove

      • Linda_Cowie
      • 2 days ago
      • Reported - view

       thanks for the suggestion, do you have a picture of the result you saw?

      • Ove_Sandau
      • 2 days ago
      • Reported - view

      Hi  

      Very rough, but this works:

      You can use the arrows to go through more tabs.

      A neater way would potentially be to use a parameter to choose which tab to use 

      The top slicer can of course be changed to be buttons or something:

      You have to be careful though, as if you set the filter on, say barcode, and then after select SKU, it's probably still linked to the barcode.

      Hope this helps a bit.

      Hopefully someone else has other ideas as well.

    • VP Product Management
    • Ian_Macdonald
    • 2 days ago
    • Reported - view

    Hi  ,

    Ove is right, this is the right way to approach this.

    Take a look at this Help page for more detailed examples of how to set it up.

    Hope that helps!

    Ian

Content aside

  • Status Answered
  • 2 days agoLast active
  • 4Replies
  • 22Views
  • 3 Following