graphic2
graphic1

Exam 77-427 Microsoft Excel 2013 Expert
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Use PowerPivot Perspectives (Power Pivot Reports)

pic1

Use the Report Titles

Placing a Field in the TITLE created a dynamic Power View. You gotta try this!

 

8. Try it: Select the Power View Titles

Click on a Title: Beverages.
The Titles Filtered the data to show Beverages.


Click on a Different Title: Breakfast.
Now, the PivotTable shows only Breakfast Items.

 

What Else Do You See? This Power View is based on the Data Model we created in PowerPivot. This is the Perspective for Paris. The prices are formatted for Euros, not Dollars.

OK, Please Do This: Rename the Sheet
Double-click the Tab.
Type: Power View Paris.

Keep going...

Power View-> View->Field List

graphic3