Forum Discussion
Slicers: remove items with no data
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 slic...
These slicers are on Table or on PivotTable? Are there any relationships between fields in slicers or they are independent?
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!!
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.