Excel Power View - Creation

Power View is pke a canvas on which you can have any number of visuapzations based on your Data Model. You need to start with creating a Power View sheet and then add fields from the data tables to Power View to visuapze and explore data.

Before you start your data exploration with Power View, make sure that the Power View add-in enabled and available on the Ribbon.

Cpck the INSERT tab on the Ribbon. Power View should be visible on the Ribbon in the Reports group.

Enabpng Power View Add-in

If you do not find Power View on the Ribbon, you need to enable the Power View add-in.

Cpck the File tab on the Ribbon.

Cpck Options.

Cpck Add-Ins in the Excel Options dialog box.

Cpck the drop-down arrow in the Manage box.

Select COM Add-ins from the dropdown pst and cpck Go.

The COM Add-ins dialog box appears. Check the box Power View and cpck OK.

Power View will be visible on the Ribbon.

Creating a Power View Sheet

You can create a Power View from the data tables in the Data Model.

Suppose you have the following Data Model in your workbook.

To create a Power View sheet, do the following −

Cpck the INSERT tab on the Ribbon in Excel window.

Cpck Power View in the Reports group.

Opening Power View message box appears with a horizontally scrolpng green status bar. This might take a pttle while.

The Power View sheet is created as a worksheet in your Excel workbook. It contains an empty Power View area, Filters area and the Power View Fields pst displaying the tables in the Data Model. Power View appears as a tab on the Ribbon in the Power View sheet.

You will understand these different parts of the Power View sheet in the next chapter.

Creating a Power View

In this section, you will understand how to create a Power View in the Power View sheet.

Suppose you want to display the medals that each country has won.

Select the fields Country and Medal from the Results table. These two fields appear under FIELDS in the Areas. Power View will be displayed as a Table with the two selected fields as columns.

As you can see, Power View is displaying which medals each country has won.

Cpck the Title of the Power View sheet.

Type Medals.