Slicers: remove items with no data

%3CLINGO-SUB%20id%3D%22lingo-sub-1890453%22%20slang%3D%22en-US%22%3ESlicers%3A%20remove%20items%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1890453%22%20slang%3D%22en-US%22%3E%3CP%3EI%20connected%20several%20slicers.%26nbsp%3B%3CSPAN%3EThe%20items%20are%20shaded%20if%20they%20are%20without%20any%20data%20so%20i%20select%20%22hide%20items%20with%20no%20data%22.%20This%20option%20works%20only%20temporarly%20because%20when%20I%20select%20an%20item%20in%20the%20first%20slicer%2C%20the%20option%26nbsp%3B%22hide%20items%20with%20no%20data%22%20is%20unset%20and%20again%20it%20shows%20data%20withowt%20items.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20tried%20everything...%20I%20don't%20know%20if%20I'm%20missing%20something%20or%20removing%20items%20with%20no%20data%20is%20just%20not%20possible%20with%20multiconected%20slicers.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20any%20suggestion!%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1890453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1890663%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%3A%20remove%20items%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1890663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F870316%22%20target%3D%22_blank%22%3E%40alexandra_giu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThese%20slicers%20are%20on%20Table%20or%20on%20PivotTable%3F%20Are%20there%20any%20relationships%20between%20fields%20in%20slicers%20or%20they%20are%20independent%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1891536%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%3A%20remove%20items%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1891536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20reply!%3C%2FP%3E%3CP%3EThe%20slicers%20are%20on%20Pivot%20Table.%3C%2FP%3E%3CP%3EThe%20purpose%20is%20to%20show%20the%20results%20of%20a%20survey%20that%20took%20place%20in%20three%20different%20cities%3A%3C%2FP%3E%3CP%3EFirst%3A%20from%20a%20single%20database%2C%20I%E2%80%99ve%20created%20about%2020%20PivotTables%20with%20the%20responses%20of%20each%20question%3C%2FP%3E%3CP%3ESecond%3A%20Made%20a%20slicer%20called%20%E2%80%9CGeographical%20area%E2%80%9D%20that%20include%20the%203%20cities%20and%20connects%20all%2020%20PivotTables.%20(no%20complains%20on%20this%20slicer%20%3AD)%3C%2FP%3E%3CP%3EThird%3A%20For%20some%20of%20the%20PivotTables%2C%20I%E2%80%99ve%20made%20specific%20slicers%20(not%20connected%20to%20any%20other).%20The%20items%20with%20no%20data%20are%20shaded%20so%20I%20select%20%E2%80%9Chide%20options%20with%20no%20data%E2%80%9D%20and%20works%20perfectly.%20The%20problem%20is%20when%20I%20select%20another%20city%20from%20the%20%E2%80%9CGeographical%20area%E2%80%9D%2C%20the%20other%20Pivot%20Tables%20show%20again%20the%20items%20with%20no%20data%E2%80%A6%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I connected several slicers. The items are shaded if they are without any data so i select "hide items with no data". This option works only temporarly because when I select an item in the first slicer, the option "hide items with no data" is unset and again it shows data withowt items. 

I tried everything... I don't know if I'm missing something or removing items with no data is just not possible with multiconected slicers.

I would really appreciate any suggestion!

Thanks in advance

4 Replies

@alexandra_giu 

These slicers are on Table or on PivotTable? Are there any relationships between fields in slicers or they are independent?

@Sergei Baklan 

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…  

@Sergei Baklan 

 

One more thing

I made a dynamic graph with the top 5 responses but the slicer shows all responses of that question. Is there a possibility to have only those 5 options in the slicer?? The same ones as in the graph?

 

Thanks a lot!!

@alexandra_giu 

Sorry, missed you previous message.

If slicers are for PivotTable that's important do you work with data model or not, what are relationships between tables and which ones you use for slicers. 

Top5 if that's not separate table and just filter on PivotTable - nope, afraid slicer will show everything.