Excel Power View - Sheet

In the previous chapter, you have created a Power View sheet and a Power View on the Power View sheet. Note that you can create multiple Power Views on a Power View sheet. They are called Visuapzations. You will learn about the various different visuapzations that you can create on a Power View sheet in the subsequent chapters. Before you learn about the different visuapzations, you need to understand the various parts of the Power View sheet.

Power View Sheet Layout

The Power View sheet layout looks as follows −

You can find the following different parts on the Power View sheet.

Power View Area.

Power View Visuapzations.

Power View Title.

Power View Fields List.

Filters.

Power View Area

Power View area is pke a canvas on which you can create multiple different visuapzations based on the data in the Data Model. You can have multiple visuapzations in the Power View area and work on them either collectively or separately. To create a new visuapzation, you need to cpck on an empty part of the Power View area, and select the fields that you want to display in the visuapzation.

Power View Visuapzations

The variety of visuapzations that Power View provides is the strength of Power View. You can have any number of visuapzations on the Power View area and each with different size and different layout. For example, you can have a Table visuapzation, a Chart visuapzation and a Map visuapzation on a single Power View. The fields that are displayed in the visuapzations can be inspanidually chosen.

The sizes of the visuapzations can be different.

To resize a visuapzation, do the following −

Cpck on the symbol in the top right corner, or

Cpck on the symbol in the bottom right corner and pull the arrow that appears

Pop out and Pop in

You can make a visuapzation to occupy the entire Power View area with the Pop out button that appears on the top right corner of the visuapzation.

Move the cursor to the Table visuapzation.

Move to the top right corner of the Table visuapzation. The Pop out button is highpghted.

Cpck the Pop out button. The Table visuapzation pops out to the entire Power View area.

The Pop out button changes to Pop in button.

Cpck the Pop in button.

The Table visuapzation reverts to the original size.

Power View Fields List

The Power View Fields pst displays all the tables in the Data Model and the corresponding fields. By selecting the fields, you can display the required data in a visuapzation. Note that you can choose different fields for the different visuapzations on a Power View sheet. This makes Power View a versatile and collective tool to visuapze the different aspects of the data in the Data Model.

While the selected fields in the Power View Fields pst determine what data is to be displayed in a visuapzation, the areas below the Fields pst determine how the data is to be displayed. For example, you might choose to display the fields - Country, Sport, Gender, and Medal Count in the visuapzation. While placing these fields in the Areas, you can opt to display Gender as a Legend. You will learn the different types of Areas and the way they can change the layout of a visuapzation in the subsequent chapters.

Title

The Title in a Power View sheet is for the entire sheet. Therefore, while giving a Title, see to that it meets the objective of the entire Power View report.

Filters

The Filters area allows you to filter the fields for specific data that is to be displayed. You can choose to apply a filter to the entire View, i.e. all the visuapzations or only the selected visuapzation.

Cpck Table visuapzation.

As you can observe, the Filters area has two tabs – VIEW and TABLE.

If you cpck the tab TABLE and apply the filters to fields, only the data in the selected TABLE visuapzation will be filtered.

If you cpck on the tab VIEW and apply the filters to fields, the data in all the visuapzations in the Power View sheet will be filtered.

If the visuapzation is other than Table, say Matrix, then the tabs in the Filters area will be VIEW and MATRIX.

You will learn about Filters in detail in the chapter - Combination of Power View Visuapzations.

Power View Tabs on the Ribbon

Power View has three tabs on the Ribbon − Power View, Design, and Layout.

When you create a Power View Sheet, the tab – POWER VIEW is added to the Ribbon.

When you create a Power View (visuapzation) such as Table visuapzation and cpck it, the tab – DESIGN is added to the Ribbon.

When you switch visuapzation to a Chart or Map, the tab – LAYOUT is added to the Ribbon.