Forum Discussion

andrecavaca's avatar
andrecavaca
Advocate II
10 years ago
Solved

Visual level filtering for slicers

I have a large set of options from which I would like to pick some specific ones and use them in a slicer to filter my data. Why Is it not possible to add a Visual level filter for a slicer when thi...
  • austinsense's avatar
    austinsense
    10 years ago

    There is a hack for this ...

     

    1. turn the visual into a bar chart

    2. apply the visual level filter

    3. turn the visual back into a slicer

shirtzel's avatar
shirtzel
Regular Visitor
9 years ago

I just went to the Ideas forum and upvoted as many posts as I could find that request this fix. This is so important! And it's so frustrating to see a Visual-level slicer on this visual, but not be able to use it!

 

In the meantime, I have a really hack-y workaround:

  • Right click on your Field, and group together all the values you don't want to show up in your filter. Name this group something that will send it to the bottom of your list, alphabetically (such as Z-Past Performances)
  • Leave all the values you'd like to see in your slicer Ungrouped.
  • In your Filter Slicer:
    • In "Field" enter your grouped Field

This will give you a Filter Slicer with all of the values you want to see, then a group of values at the very bottom that contains all the values you don't want to see. If you don't have too many values you do want to see, you can even format this filter slicer as a List and resize it so that all of the values except for the Z group at the bottom show up.