Microsoft Office Tutorials and References
In Depth Information
Creating a Power View Dashboard
Figure 17-19: You’re ready to build your pivot table analysis based on multiple external data tables.
Creating a Power View Dashboard
After you have data in your internal Data Model, you can create a Power View dashboard from that
Data Model. Just go to the Ribbon, click the Insert tab, and click Power View. Excel takes a moment to
create a new worksheet called Power ViewX, where X represents a number that will make the sheet
name unique (for example, Power View1).
This new worksheet has the three main sections shown in Figure 17-20: Canvas, Filter Pane, and Field
List.
The canvas contains the charts, tables, and maps you add to your dashboard. The filter pane contains
the data filters you define. You use the field list to add and configure the data for your dashboard.
Figure 17-20: The three main sections of a Power View worksheet.
You build up your Power View dashboard by dragging the fields from the field list to the respective
sections. For example, dragging the Generator_Size field to the filter pane creates a list of filterable
items (see Figure 17-21) that can be checked and unchecked. The filter pane has a few icons that help
Search JabSto ::




Custom Search