Slicer Help!

[bp107]

Hello!

I am working with a slicer that has 88 options. (yes I need to display all 88 of them). To make the slicer more use friendly and not be so confusing, I would like to have 2 or 3 different slicers that include a few of the 88 options. Ex: Slicer 1 has options 1-30, slicer 2 has options 31-55, etc.

Essentially I just want to organize them seperately so the user can go to a specific section to select what they need. 

Is there anyway to do this?? HELP!

[DOLEARY85]

Hi, 

you could use the filter pane on each slicer - use the field name under filters on this visual and just select the items you want in each one

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
 

[bp107]

I have been able to create the seperate slicers and filter them to the options I would like. But when I select one option from more than one slicer, the matrix is then blank. What else can I do?

[DOLEARY85]

Ah okay, if you need to select multiple items that won't work.

I suppose the next option could be to create natural groups for the items and put the groups and the column values into one slicer so at least it breaks it down a bit. e.g:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍