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.

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:

Under HomeTab -> Click on Get data -> Select Excel Workbook -> then select the excel sheet

Select the sheet check box and click on load.

Steps to Create Matrix

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

Step 2: To fill the values in the matrix, there are three fields:

• Row- In this demonstration, we placed ‘Product’ in this field
• Column- In this demonstration, we placed ‘Country’ in this field
• Values- In this demonstration, we placed ‘Quantity Sold’ in this field

Dragged and Dropped

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

Formatting under Visual

1. To give Bold Headers in the Matrix. Click under Style Present and select Bold Header in the drop-down

2. To show the separation between the row and the column. Click on the grid and ‘on’ the vertical and horizontal grid lines and increase the font size if required

3. To increase readability you can use alternate text colors to the matrix. Click on values and play with the background and alternate text color

Formatting under General

1. To give Title to the Matrix. Click on the Title option and make it ‘on’ and give Title according to the need.

2. To change the background color of the matrix. Click Effect and make the Background button ‘on’ and select the background color.

3. To make the header Icon more attractive. Click on the Header icon and make it ‘on’ also select the color as per the requirement.

Application of Matrix

Matrices have the following uses in our day-to-day life. Some of the uses of matrices in diurnal life are mentioned below:

• Encryption: A veritably common use of matrix in diurnal life is during encryption. We use it to scramble data for security purposes and to render and crack this data, we bear matrices. There’s a key that helps render and crack data which is generated by matrices. 
• Games especially 3D: One operation of matrices is in games. They use the 3d matrix to the 2d matrix to convert it into different objects as per demand. 
• Economics and Business: To study the trends of a business, shares, etc., and to produce business models. 
• Construction: Another common operation of matrices in real life is the construction sector. Have you seen some structures that are straight but occasionally engineers try to change the external structure of the structure? This can be done with matrices. Matrix provides an easier way to change the number of rows and columns within a matrix. Matrices can help support colorful literal structures. 
• Cotillion: Contra cotillion – It’s used to organize complicated group balls. 
• Vitality: It can help make robustness more precise and accurate. 
• Geology: Matrices are used for taking seismic checks.

Power BI Matrix Vs Table 

Then we will the difference between the Power bi matrix vs table. 

Matrix	Table
The power bi matrix is multi-dimension like an excel pivot table.	Whereas power bi table 2- Dimension visual to represent irregular data.
In the power bi matrix, you have the option to add further confines to rows, columns, and value fields.	In the table, if you want to add a further dimension, also you have to add it to the value field, it’ll appear in the new column.
The power bi matrix automatically summations the data and enables you to drill down	But there’s no easy way to epitomize the advanced dimension in table visualization and drill down further to the lower dimension.
In the power bi matrix rows and columns aren’t fixed.	In the power bi table rows aren’t fixed and columns are fixed.