Home > SQL Server > Power Pivot Slicer Settings

Power Pivot Slicer Settings

Here’s a quick tip I thought I’d share with you. Those of you who are using Powerpivot will know that Slicers  are one of the best features of Excel 2010 and PowerPivot.

Slicers make it easy to use this workbook

Power Pivot Example

I find that some people aren’t aware of the slicer settings tab. Here you can tweak the look and feel of the slicer pane , but there is a setting that can improve performance. To access the tab , click on the slicer you want to edit, prefereably on the name of the slicer itself. You will then notice that on the Office Ribbon at the top, the “Slicer Tools” option appears.

The slicer tab appears on top , allowing you to change slicer settings

Now here there are an avalanche of options falling out of the ribbon, ranging from styles and sizing to renaming the slicer. The two that you might be interested in are the “Slicer Settings” and “PivotTableConnections” buttons , both on the left. When you click on PivotTable Connections, you get a little pop up box. Here you can define which source tables the slicer loads data from. This is useful when you back end data has changed.

Data Connection Settings

Data Connection Settings

When you click on Slicer Settings , there are a few more interesting options. You can Rename and Re-Caption the Slicer, and set the sort order. The one that is interesting however , is the “Visually Indicate items with no data” option.

Slicer Settings

When you have a large amount of large slicers , you may experience some performance issues ( Even with the mighty Vertipaq engine ). You can therefore uncheck this option and it should help out with the performance of your workbook when slicing and dicing.

Categories: SQL Server
  1. Michael Wade
    June 27, 2011 at 12:02 pm

    Very good post, really informative. What about a blog post on SQL Jobs? It took me months to find a decent job in SQL. I found this site to to be quite useful in the end

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: