Matrix Visualization in Excel Power View

A matrix is a sort of visualization that, like a table, is made up of rows and columns. A matrix, on the other hand, may be deflated and enlarged by rows and/or columns. You can dig down/drill up if it has a hierarchy. Totals and subtotals can be shown by columns and/or rows. A matrix, on the other hand, may present data without repeating values. In this article, we will learn about Matrix Visualization in Power View.

Matrix Visualization

Let’s take a dataset as an example in order to understand matrix visualization. This is the major dataset that will be used in this case.

Steps to Create a Matrix Visualization

Step 1: To make a matrix, begin with a table. Choose from the following options: Country, Region, Festival, and Days. In Power View, a table with these fields is displayed.

Step 2: Convert the table to a matrix now. Select the Table. Navigate to the DESIGN tab. In the Switch Visualization group, choose Matrix from the dropdown menu.

Step 3: As you can see, The Table has been changed to a matrix.

Subtotals and Totals

In this, we can see how we can show display the total and subtotal, by default it is displayed. But if we don’t want to display then we need to follow these steps. If you do not want the Subtotals and Total rows to be displayed in Matrix, perform the following: Select the Matrix. Navigate to the DESIGN tab. 

In the Options group, click Totals and choose None from the dropdown menu.

Subtotals and Totals will no longer be presented, as you can see.

If you want the Subtotals and Total rows to be displayed again in Matrix. Select the Matrix. Navigate to the DESIGN tab. In the Options group, click Totals and choose Rows from the dropdown menu.

Rows containing Subtotals and Totals will be shown. As you can see, this is Matrix’s default setting.

Power View Filtering Matrix

You may go through the data to locate Countries and the related religion and festivals that have more than 2 days. Select Matrix. Click the MATRIX tab in the Filters section. Set the Days filtering criteria to – is greater than or equal to 2. Click the Apply filter button.

The matrix displays data without repeating the values.

Benefits of Matrix Visualization

The following are the benefits of using a matrix:

1. It is capable of displaying data without repeating values.
2. Rows and/or columns can be compressed and enlarged.
3. You can dig down/drill up if it has a hierarchy.
4. Totals and subtotals can be shown by columns and/or rows.