O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

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

Using PivotTables with tabular data

These recipes explain how to do fundamental operations with PivotTables against a tabular model. You will create slicers in Excel. You will then see how to sort and filter the data within Excel that is connected to your model.

Using Slice, Sort, and Filter

In this recipe, you will learn how to insert a slicer, filter your data, and sort the data in an Excel PivotTable.

How to do it...

  1. Connect to the model as described in the Connecting to Excel from SQL Server Data Tools recipe.
  2. On the Analyze menu, click on Insert Slicers to bring up the Insert Slicers window:

    How to do it...

  3. Scroll down and select the LIGHT_CONDITION checkbox and ...

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