Slicer showing top 10 values only

Hi Guys,

My source data has 14,000+ lines, I have 292 customers.

I create a pivot table and sort by top ten, easy and helpful.

However, when I insert a slicer to create my dashboard, pivot charts etc, I see all 292 customers in the slicer.

Not only does this mean there is too much scrolling but also it means that from the slicer alone the user no longer knows who the top ten customers are.

I have search high and low but to no avail.

I will take any help, possible solution that you guys have and will be vert grateful.

Thanks

did you try to group them maybe this help you
at this video duration 5:33
https://www.youtube.com/watch?v=v-0Z4qGS0xk

Hi shj92922,

It has given me some ideas for work arounds.

Thanks for your help.