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

sumit4732's avatar
sumit4732
Advocate II
9 years ago

Hi,

There is a workaround to it: 

1. Create a copy of the slicer so you have two slicers on the page (let's call them "SL1" and "SL2")

2. On SL2, select the values you want to see appear in the actual slicer (this is NOT using the visual filter of the slicer, just select the values from the actual slicer)

3. SL1 will now be showing ONLY the values you have selected in SL2. 

4. With SL1 switch "ON" background and set transparency to 0%

5. reduce the size of SL2 to something smaller than SL1 and Drop it "behind" SL1 to hide it. 

This will get the work done.

Thanks GregM for the edit 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks sumit4732  That worked... 

     

    To be clearer for other users...

    1. Create a copy of the slicer so you have two slicers on the page (lets call them "SL1" and "SL2")

    2. On SL2, select the values you want to see appear in the actual slicer (this is NOT using the visual filter of the slicer, just select the values from the actual slicer)

    3. SL1 will now be showing ONLY the values you have selected in SL2. 

    4. With SL1 switch "ON" background and set transparency to 0%

    5. reduce the size of SL2 to something smaller than SL1 and Drop it "behind" SL1 to hide it. 

     

    Thanks again sumit4732

     

    Best Regards

    Gerard

     

    • ararat07's avatar
      ararat07
      Frequent Visitor
      8 years ago

      Thanks @sumit4732 It's a great workaround! Just wanted to add that you can hide SL2 in the Selection Pane, it will eliminate the need for step 4 and 5.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I just saw another option for this that Mike_Carlo came up with. Since we can show and hide things on a page, he just copied a slicer, filtered it, then hid the slicer. The other slicer retains the same context without the filtered out value and no one is the wiser. A bit harder for someone else to discover :) but its super quick without the need to layer things. As a seperate note I just thought of, it would be easy to just create a bookmark page that contained the filtered slicers, would be easier to discover.