O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting pivot tables and Slicers

Excel 2010 introduced new functionality into Excel in the form of Slicer controls. A Slicer can be thought of as an Excel data control that connects to multidimensional data as a client tool, which has built-in functionality for interacting with pivot tables. Since the tabular model is presented to Excel as a multidimensional model (it is essentially a server model stored in Excel and accessed through Excel's client tools), the pivot table and Slicer can connect to the tabular model.

In fact, the PowerPivot Field List is a special field list for interacting with a pivot table based on the tabular model that includes two window groups for horizontal and vertical Slicers, as shown in the following screenshot (the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required