Forum Discussion
Slicers: remove items with no data
These slicers are on Table or on PivotTable? Are there any relationships between fields in slicers or they are independent?
Thank you for the reply!
The slicers are on Pivot Table.
The purpose is to show the results of a survey that took place in three different cities:
First: from a single database, I’ve created about 20 PivotTables with the responses of each question
Second: Made a slicer called “Geographical area” that include the 3 cities and connects all 20 PivotTables. (no complains on this slicer :D)
Third: For some of the PivotTables, I’ve made specific slicers (not connected to any other). The items with no data are shaded so I select “hide options with no data” and works perfectly. The problem is when I select another city from the “Geographical area”, the other Pivot Tables show again the items with no data…