Filtering in Dashboard!

[bgrish3]

So i need a little help with my Dashboard. I have all the charts i need in my dashboard and now i need to be able to filter through it all. I know i can use slicers, but a few of my categories have over 100 choices and going through a slicer and finding multiple things can get a bit annoying. i was wondering if there is any other way to filter through your data/charts. I was hoping there would be a way to have something similar to the filters you can have in the pivot table where you can search and click multiple options. If there is any way anyone can think of weather its a complicated code or anything, please let me know.

Thanks!!

[zbor]

You can hit multiple slicers options by Ctrl+Click (single) or Shift+Click (range)

[bgrish3]

Yes I know that, but holding control scrolling through over 100 options trying to find specific ones can get annoying and i can do it way faster by just going to the data and filtering that way. I was wondering if there is a way to filter through multiple charts using something similar to the filtering tool in regular data.

[zbor]

You can put several slicers.
First out one group then second etc
Until you get reasonable amount in last slicer.

If you can do that.
If you have for example 100 names without any other criteria then you can't do that.
But if you have slicers as male/female, department, region... then you can filter out first Texas then next...

I don't know how your data is organized so this is just general guidance.

[bgrish3]

Ya I have about 7 slicers in my Dashboard, but sometimes I want to filter by only 2 or 3 suppliers or sometimes just 1 and nothing else and i either have to scroll down for 2 minutes or just go in my data and filter through there but i was hoping there would be a better way to filter inside my dashboard but i guess not

[dflak]

Maybe I'm missing the question. But if you have 100 slicer items, do you not also have 100 choices on a pivot table filter? I don't see where one is easier than the other.

Also it would help a lot to be able to see a sample workbook.