SQL Server Home
Cannot resize the slicer (vertical or horizontal) window
as By Design
4/26/2010 7:12:42 AM
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.
SQL Server 2008 R2 November CTP –“Gemini” Add in
Windows Vista SP1
Operating System Language
Steps to Reproduce
- Create a excel worksheet based on four chart Powerpivot template;
- Put a slicer (horizontal or vertical);
- Attempt to resize the slicer window;
- The slicer window return automatically to the original size.
- The slicer window keep with the new size.
to post a comment.
Please enter a comment.
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.
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
to post a workaround.
Please enter a workaround.
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...
© 2014 Microsoft