Matrix

A matrix is a type of visualization that’s analogous to a table in that it’s made up of rows and columns. still, a matrix can be collapsed and expanded by rows and/ or columns. However, you can drill down/ drill up, If it contains a scale. It can display summations and subtotals by columns and/ or rows. A matrix can display data by removing the repeating values.

Power BI – How to Format Matrix?

Power Bi is an extensively used operation as it helps in storing, assaying, calculating, etc. data. Power Bi contains numerous functions that are used to maintain and show data in a presentable way. Matrix is one of the Power Bi is handy functions, it’s a collection of figures that are arranged into several columns and rows. Matrix could contain complex figures still we won’t see those numbers.

Similar Reads

Matrix

A matrix is a type of visualization that’s analogous to a table in that it’s made up of rows and columns. still, a matrix can be collapsed and expanded by rows and/ or columns. However, you can drill down/ drill up, If it contains a scale. It can display summations and subtotals by columns and/ or rows. A matrix can display data by removing the repeating values....

Creating a Matrix

To create a Matrix we will import a Data set in the Workspace of power Bi. Steps to import Excel Sheet are given below. The dataset used for the same is given here. Below is the screenshot of the dataset as well:...

Steps to Create Matrix

Step 1: Click on the Matrix icon under the visualization, Resize it if required....

Steps to Format Matrix

To format Matrix Always make sure that Your matrix box is clicked once by the cursor. There are two types of Formating Visual and General...