Home Dashboard Directory Help

Cannot resize the slicer (vertical or horizontal) window by C.Monteiro


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 554055
Opened: 4/26/2010 7:12:42 AM
Access Restriction: Public
User(s) can reproduce this bug


I have an excel worksheet with graphics, that has been built using the PowerPivot four chart template. When I put the slicers (horizontal or vertical) I cannot resize the slicer window. The slicer window return automatically to the original size.
Sign in to post a comment.
Posted by Microsoft on 5/4/2010 at 11:45 AM
The slicer frames are designed to help automatically adjust the fields within the frames in as a group, which means that you are not able to adjust each slider individually. In order to adjust to the size of the slicers you need to select and adjust the outer slicer frame. Select the PivotTable or PivotChart to activate the frame, you should now see the outer frame containing all slicer fields. Now re-adjust the size of the frame.
Posted by Microsoft on 4/29/2010 at 10:21 AM
Thank you for filing this feedback item. We will investigate the reported behavior for a future release of SQL Server. This item will be updated with information as we have more to report.

Thanks for your assistance,
Analysis Services team
Sign in to post a workaround.
Posted by G Wade on 10/29/2010 at 8:32 AM
I did accidentally discover a workaround for this, though it has the slight drawback of making the slicer field disappear from the pivot table slicer field list. However, the slicer buttons remain bound to associated pivot table and/or charts.I found the default behavior incredibly annoying, as it doesn't allow you to resize the buttons (well, it does, but it resizes them back the next time you touch the slicer - infuriating!).

Here's how to break free of the size constraints:

When you first create a slicer, you'll notice a blue rectangle surrounding the buttons, and outside of that, a gray slicer frame rectangle.
Click on white space inside the blue rectangle of the slicer, and drag the slicer completely outside of the gray slicer frame rectangle.
Click on the gray slicer frame rectangle so the drag handles are shown. (If the slicer frame rectangle disappears before you actively delete it, click in the pivot table area, and it should reappear.)
Press the "Delete" key to delete the slicer frame.
Drag the slicer into the desired position.
You should now be able to resize the slicer and the buttons without the slicer snapping back into shape. Unfortunately, the slicer no longer appears in the "Slicers" field list.

Now, if I could just figure out how to change the font size/style...