Do you want to use a Matrix visual in your Power BI report? In this Power BI tutorial, I will explain everything about the Power BI Matrix, like what a matrix is and **how to create a matrix visual in Power BI**.

Also, we will discuss all the differences between the Power BI Table and the Power BI Matrix.

Moreover, I will explain the Power BI tabular format, how to remove the plus sign in the Power BI matrix visual, and how to remove the total in the matrix visual with various examples.

## What is a Matrix Visual in Power BI?

The Power BI matrix visually simplifies the meaningful display of data across multiple dimensions and supports a stepped layout for better organization. Power BI Matrix aggregates the data itself and lets users drill down.

The image below displays a matrix visual where the rows field contains the city, the columns field contains various regions, and the value field contains sales.

## How to Create a Matrix Visual in Power BI

Now, I will tell you how to create a Power BI matrix visual in simple steps:

I have a SharePoint list, i.e., **Orders **having these below fields with different data types:

Columns | Data Types |
---|---|

Order Date | Date and time |

Country/Region | Single line of text |

City | Single line of text |

Region | Single line of text |

Category | Single line of text |

Sub-Category | Single line of text |

Product Name | Single line of text |

Sales | Currency |

Quantity | Number |

**1**. Open Power BI Desktop and load data using the **Get data** option. Then, we can see the data set in the Data Panel.

**2**. Under the Visualization panel, click **Matrix **Visual.

**3**. Now drag Product Name into Rows, Category into Column, and Sales into Values. Check the screenshot below.

In this way you can create a matrix visual in Power BI.

## Power BI Table vs Matrix

Here, we will discuss the difference between the Power BI table and the matrix.

Power BI Table | Power BI Matrix |
---|---|

1. Power BI Table displays data in a basic row and column format, similar to an Excel table. | 1. Power BI Matrix displays data dynamically in rows and columns, providing a more structured view. |

2. Power BI Table displays detailed information without summarization. | 2. Power BI Matrix is suitable for summarizing and comparing data. |

3. In the Power BI table, rows are not fixed, and columns are fixed. | 3. In the Power BI matrix, rows and columns are not fixed. |

4. Each row in the Power BI table represents a unique record; columns represent attributes. | 4. In the Power BI matrix, organize data dynamically for two-dimensional comparison. |

## Power BI Matrix Tabular Format

Now, I will describe the tabular form of the Power BI matrix in Power BI Desktop.

I hope you open Power BI Desktop and load the data using the **Get data** option.

**1**. Under the visualization panel, click the matrix visual. Then, drag and drop the **Region** and **City** into the **Row** field. Then, drag the **Sales** into the **Values** field.

**2**. In the matrix visual, expand each row by clicking on the plus (**+**) icon.

**3**. Click on the **Format you visual** -> Expand the **Row header** section -> Expand the **Options** -> Turn off the **Stepped layout**.

**4**. In the screenshot below, you can see the Power BI matrix tabular format.

You can follow the above steps for the Power BI matrix tabular format.

## Power BI Matrix Remove Plus Sign

I will show you how to remove plus sine in the Power BI matrix.

I hope you do the above example(Power BI Matrix Tabular Format).

1. In this example, Click on the **Format you visual** -> Expand the **Row header** section -> Turn off the **+/- icons**.

Check the screenshot below; the plus(+)icon was removed.

This way, you can remove plus(+) icons in the power BI matrix.

## Power BI Remove Total from Matrix

Now we see how to remove the total in the Power BI Matrix visual:

- Power BI Removes the Total Row from the Matrix.
- Power BI Removes the Total Column from the Matrix.

### Power BI Removes the Total Row from the Matrix

Now, we see how to remove the total row from the matrix visual in simple steps.

I hope you open Power BI and load data.

**1**. Under the Visualization panel, click Matrix Visual and drag City into Rows, Region into Columns, and Sales into Values field.

**2**. In the Visualization panel, click **Format your visual** -> **Visual** -> turn off the **Row Subtotals**.

This way, you can remove the row total in the Power BI Matrix visual.

### Power BI Removes the Total Column from the Matrix

Now, we see how to remove the total column from the matrix visual in simple steps.

I hope you open Power BI and load data.

**1**. Under the Visualization panel, click Matrix Visual and drag City into Rows, Region into Columns, and Sales into Values field.

**2**. In the Visualization panel, click **Format your visual** -> **Visual** -> turn off the **Column Subtotals**.

In this process, you can remove the column total in the Power BI Matrix visual.

## Conclusion

I hope you follow the above steps to create a matrix visual in Power BI. In this Power BI tutorial, I explained what a matrix is, how to create a Power BI matrix visual, and the difference between the Power BI Table.

Also, I explained how to remove the plus sign in the Power BI matrix visual and how to remove the total in the matrix visual.

Moreover, you may like some more Power BI tutorials:

- Create a Pivot Table in Power BI
- Create a Measure in Power BI
- How to Select Multiple Values in Power BI Slicer
- How to Sort Columns in Power BI Matrix Visual?

Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book **Microsoft Power Platform A Deep Dive.**Â She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.