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...
- Connect to the model as described in the Connecting to Excel from SQL Server Data Tools recipe.
- On the Analyze menu, click on Insert Slicers to bring up the Insert Slicers window:
- Scroll down and select the LIGHT_CONDITION checkbox and ...
Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
