Forum Discussion

andrecavaca's avatar
andrecavaca
Icon for Advocate II rankAdvocate 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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

andrecavaca - You should definitely post to Ideas, but why not just use Enter Data or another query to create a table with just the values you want, relate the two tables and use the second table as your slicer? Boom!

XLBob's avatar
XLBob
Icon for Resolver II rankResolver II
10 years ago
I think the query is the better option so you can to some extent keep your filter list dynamic. You can either write a new query or use table measure to do that.