Hey,

I have a power pivot with over 10,000 rows of data. I have used a power pivot to group this data by product and then by materials in product. I am interested in looking at the top 20 products and the amount made over the past year in each month. I put a filter on my powerpivot table to achieve this. I created a pivot chart that mapped out the products made against month. However, I want this chart to be able to show only one product at a time.

I inserted a slicer in but the slicer has the all the products in the list (over 100).

Is there a way to set the slicer so that it only shows top 20 products to make it easier to select.

I was thinking if I could delete the non filtered data this would work but can't find that option on excel.


Thanks,
D