Hello and thank you for viewing my post.
I have a spreadsheet that has 5 pivot tables on 1 tab and I've created the graphs and copy / paste those graphs onto the Dashboard tab. When I add the sliders; 5 in total, I connect 3 of the graphs to the slicer without issue but when I connect the 4th slicer it clears the "Keep only selected" filter for that pivot and shows everything in that pivot even after I have select only 10 items to keep from the list of hundreds.
Is there a way to keep the filter of only the 10 I selected to keep without having the slicer clear the filter?
I have a spreadsheet that has 5 pivot tables on 1 tab and I've created the graphs and copy / paste those graphs onto the Dashboard tab. When I add the sliders; 5 in total, I connect 3 of the graphs to the slicer without issue but when I connect the 4th slicer it clears the "Keep only selected" filter for that pivot and shows everything in that pivot even after I have select only 10 items to keep from the list of hundreds.
Is there a way to keep the filter of only the 10 I selected to keep without having the slicer clear the filter?
