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
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 ...