Make slicers visible "On Demand".
Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up
The core benefit of this function would be to reduce the amount of physical space occupied by static slicers on a crowded pivot table page. Slicers are superior to report filter boxes since the indicate which field parameters are not available due to other filtering actions on the same pivot.
A VBA-enabled file is provided as an example, which is also published at www.contextures.com
Kim Mullins commented
Alex has a valid idea. We who use Slicers on a regular bases would welcome this feature!
Thank for keeping all the MS Product line number one in innovative tech. that makes our work less probematic, and delivery so professional looking!