Home » Power BI » Power BI – Matrix Vs Table Visualizations

Power BI – Matrix Vs Table Visualizations

Matrix vs Table Visualization

Introduction

Power BI Matrix & Table both are most frequently usable visuals used for presenting data in tabular format.



Table

  • In table we present data in 2-Dimension data grid format.
  • By default display all data, means flat data structure.
  • Rows not fixed but columns are fixed.
  • When you add new dimension you can add them as “Values” and it will appear as a new column in grid.




Matrix

  • It support Multidimensional data grid format.
  • Matrix automatically aggregate the data according to data behavior.
  • Rows & Columns both are not fixed.
  • Here you have option to add Values, Rows & columns.

Important Note : Show values on rows for matrix visual

Let’s start with an example:

Download Sample data : SuperStoreUS-2015.xlxs

Now create a table visual to using three fields :-  Customer Name, Customer Segment & Discount.

In this data we have multiple entries of same users against different-different Customer Segment & Discount.



So, by default Table visual will display all data, means flat data structure.

Table Visual Example

Table Visual Example

And when we display same data in Matrix Visualization, it will aggregate the data automatically, so you can see the output in below screen shot now Customer name is not repeating.

Matrix Visual Example

Matrix Visual Example



For Data Analysis purpose Matrix Visual is good and easy to understand. In Matrix we can transform the Data Column wise as well.

See below screen shot, here we displaying data column wise to using Matrix three property Rows, Column & Value.

Row to Column Transform

Row to Column Transform

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Recommended Post:

Power BI Performance Analyzer

How to create Custom Theme in Power BI

Custom Tooltips in Power BI

Enable Syncs Slicers in Power BI

Power BI Interviews Q & A

Group in Power BI

Hierarchies in Power BI

Leave a Reply