Working with a matrix in Power View
A matrix is a type of visualization that is similar to a table in that it is made up of rows and columns. However, a matrix can be collapsed and expanded by rows and/or columns. If it contains a hierarchy, you can drill down/drill up. It can display totals and subtotals by columns and/or rows. And a matrix can display data without repeating values. For example, visualizing data about Olympic sports, disciplines, and events:
On the left, the table lists the sport and discipline for each and every event.
On the right, the matrix lists each sport and discipline only once.
To create a matrix, you start with a table and convert it to a matrix.
On the Design tab > Switch Visualizations > Table > Matrix.
By default a matrix has totals, and subtotals for the groups, but you can turn them off.
On the Design tab > Options > Totals.
To add column groups, drag a field to the Column Groups box.
Tip If you don’t see the Column Groups box, make sure Matrix is selected on the Design tab.