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

Creating a Power View report

The first recipe examines how to create a Power View report and navigate the reporting surface. Our goal is simple, we have been asked to investigate trends in sales by Product Category, Month, and Country. This is done by creating a grid on the design surface and then manipulating it.

Getting ready

This recipe is based on the PowerPivot model shown above—the model in the workbook (Sales Model 2013.xlsx) is available from the online resources. Once a tabular model has been converted to an Excel 2013 format, the model is no longer compatible with the Excel 2010 add-in (and cannot be opened or used in Excel 2010).

All the tabular modeling features that relate to Power View can be set in Excel 2010 (the same menu paths are ...

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