Using Power View in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 135

will add horizontal or vertical scroll bars to the table if the amount of data cannot display fully in the
newly allocated size. Because the Power View sheet size is fixed, you must add another sheet to your
workbook if you want to create more tables or other data visualizations.

You can also move a table to a new location in the view. First, click the table to display the borders.
When the mouse pointer turns into a hand, drag the table to another area of the view. You can move
it to a blank area of the view or place it on top of another data visualization. You can even copy or
move it to another Power View sheet, but you must use the Cut, Copy, or Paste buttons on the Power
View tab on the ribbon to do that.

Creating a matrix
Whereas you use a table to aggregate numeric values as row groups, you use a matrix when you
want to aggregate by both row and column groups. You use the layout section below the Power
View Fields list to define the fields to group as rows or as columns as well as the values to aggre-
gate. Optionally, you can configure a matrix to use a hierarchy so that you can drill from one level to
another as you explore your data.

Converting a table to a matrix
As with any visualization, you can start a new matrix by creating a table and then use a command on
the ribbon to convert it to a matrix. As an alternative, if you already have another type of visualization
in the view that you want to replace, you can select it and convert it to a matrix in the same way. Let's
copy the table in the view and convert it to a matrix.

In the View section, click the table. On the ribbon, on the View tab, click the Copy button.
Click a blank area of the View and then, back on the ribbon, click the Paste button.

1.

Power View adds the matrix to the right of the existing table if sufficient space exists for the
second table in this area. Otherwise, Power View adds it to the lower-left area of the View.

Click the new table, point to one of its borders, and then drag the new table to the area below
the first table, as shown in Figure 5-12:

2.

FIGURE 5-12 You can drag a table to a new location after pointing to one of its borders.

With the new table still selected, on the Design tab, click the Table button and then, on the
menu that appears, click Matrix, as shown in Figure 5-13:

3.