Slicer setting issues

Copper Contributor

I have a worksheet with different pivot tables in several tabs, based on 1 data list. 

 

I am using slicers to filter. 

 

IN some tabs when I add several slicers, the slicer settings work (like hide items with no data = blanc button disappears). When I select 1 item in slicer 1, all irrelevant items in slicer 2 disappear. This is what I expect. 

 

But on other tab sheets, when I add several slicers (the same often), the slicer settings do not work (like when I select "hide items with no data" nothing chages and the blanc button remains). When I select 1 item in slicer 1, nothing changes in slicer 2. All items remain, while not all of the are relevant for the item selected in slicer 1. 

 

What am I doing wrong, while I am only doing the same 

 

1 Reply

@Brains1971 

 

I am experiencing the same issue with my slicers too.

My file have 6 slicers over 48 pivot tables created from a single data model.

If anybody have any suggestions, please let us know.