Answered by:
Changing the properties of a slicer

Question
-
Hi,
I'm trying to change the properties of some slicers and the related container shape but with poor results. Fe when I try to modify the width of the cells containing the filter values then returns to the original value. Analogue result for the fill colour of the container. I'd like to adjust graphically the slicers. Is it an issue of PowerPivot?
Thanks
Thursday, May 26, 2011 9:22 AM
Answers
-
Hi pscorca,
Slicers used in pivot tables get a 'container' box by default that takes a best guess as to the proper sizing of the slicer. In order to fully control the sizing of a slicer, just drag the slicer out of the container box around it which will avoid the resizing behavior.
Javier Guillen
http://www.msbicentral.com/Blogs/JavierGuillen.aspx- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, June 28, 2011 7:38 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Wednesday, September 18, 2013 9:07 PM
Tuesday, June 28, 2011 7:05 PMAnswerer
All replies
-
Hi pscorca,
Slicers used in pivot tables get a 'container' box by default that takes a best guess as to the proper sizing of the slicer. In order to fully control the sizing of a slicer, just drag the slicer out of the container box around it which will avoid the resizing behavior.
Javier Guillen
http://www.msbicentral.com/Blogs/JavierGuillen.aspx- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, June 28, 2011 7:38 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Wednesday, September 18, 2013 9:07 PM
Tuesday, June 28, 2011 7:05 PMAnswerer -
Ok, thanks, and then can I remove this container?Thursday, June 30, 2011 11:49 AM
-
Thursday, June 30, 2011 6:18 PMAnswerer
-
Hi Javier,
how can I remove the container of one or more slicers of a PowerPivot pivot table?
I'm trying to cut unsuccessfully.
Thanks
Wednesday, June 27, 2012 8:56 AM