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.
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 used); however, the results are only visible in Excel 2013 (since this is the only version of Excel that has Power View available). An Excel 2010 version of this file is also available from the online resources.
The Power View and PowerPivot add-ins...