Forum Discussion
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 remov...
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/