Forum Discussion

PouBelle's avatar
PouBelle
Copper Contributor
Apr 12, 2026

Pivot Table TOP 5 vs Slicer

I create a Pivot Table, sort the data then filter on the TOP 5. I then create the Pivot Chart (horizontal TOP 5 bar chart). In my dashboard, I have slicers. When a Slicer filter is applied then removed, the Pivot Table and Chart do not go back to display the TOP 5 data but the whole set of data. Any simple way to ensure the pivot table / Chart recovers only the TOP 5 values (and not the whole set of values) after the slicer filters are reset ?

1 Reply

  • Worth taking a look at this, www.sageintelligence.com/tips-and-tricks/excel-tips-tricks/2016/11/how-to-prevent-slicers-from-ruining-filtered-charts-in-excel/