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

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