How to Create Matrix Visual in Power BI: Step-by-Step Guide

To create a Matrix visual in Power BI, select the Matrix icon from the Visualizations pane, then drag fields to the Rows, Columns, and Values areas. This visual organizes data in a grid format, allowing you to see data grouped by rows and columns with subtotals and totals.

Syntax

The Matrix visual in Power BI does not require code but uses a drag-and-drop interface with these main parts:

• Rows: Fields placed here appear as row headers.
• Columns: Fields placed here appear as column headers.
• Values: Numeric or aggregated data shown in the matrix cells.

These parts define how your data is grouped and summarized in the matrix.

text

Matrix Visual Setup:
- Rows: Drag field(s) for row grouping
- Columns: Drag field(s) for column grouping
- Values: Drag numeric or measure fields to display aggregated data

Example

This example shows how to create a matrix visual displaying sales data by Product Category as rows and Year as columns, with Sales Amount as values.

text

1. Open Power BI Desktop.
2. Load your sales data table.
3. Click the Matrix visual icon in the Visualizations pane.
4. Drag <Product Category> field to Rows.
5. Drag <Year> field to Columns.
6. Drag <Sales Amount> field to Values.
7. The matrix will show sales by category and year with totals.

Output

Matrix visual showing rows as Product Categories, columns as Years, and cells with total Sales Amounts including subtotals and grand totals.

Common Pitfalls

Common mistakes when creating a matrix visual include:

• Not placing fields in the correct area (Rows, Columns, Values) which leads to confusing layouts.
• Using non-numeric fields in Values, which will not aggregate properly.
• Forgetting to check data types, causing unexpected results.
• Overloading the matrix with too many fields, making it hard to read.

Always verify your data fields and keep the matrix simple for clarity.

text

Wrong:
- Dragging a text field to Values area (no aggregation)
Right:
- Use numeric or measure fields in Values for aggregation

Quick Reference

Matrix Visual Element	Purpose
Rows	Group data by these fields as row headers
Columns	Group data by these fields as column headers
Values	Show aggregated numeric data in cells
Subtotals	Show totals for each group automatically
Grand Total	Show overall total for rows and columns

Key Takeaways

Drag fields to Rows, Columns, and Values to build a matrix visual in Power BI.

Use numeric or measure fields in Values for proper aggregation.

Keep the matrix layout simple to maintain readability.

Check data types to avoid unexpected results in the matrix.

Matrix visuals automatically show subtotals and grand totals for easy analysis.