How to Create a Matrix Visual in Power BI

The Matrix visual is one of Power BI's most versatile and powerful tools for displaying data, acting much like a supercharged pivot table. It's perfect for showing information in a clear, multi-dimensional grid that users can explore interactively. This guide will walk you through exactly how to create a matrix visual, from the basics to advanced customization, to make your reports more insightful and easier to understand.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Power BI Matrix Visual?

Think of a standard table visualization: it shows your data in rows and columns, in a flat, two-dimensional format. It’s simple and effective for listing out records. A matrix, on the other hand, takes this concept into three or more dimensions. This means you can group data by attributes on both rows and columns simultaneously.

If you've ever used a PivotTable in Excel, the matrix visual will feel instantly familiar. You can add categories to the rows to create a nested hierarchy, do the same with columns, and then populate the intersection with aggregated values like sales totals, user counts, or average order value. The key benefit is its ability to present a dense summary of data that viewers can drill into for more detail without being overwhelmed at first glance.

For example, instead of just a long list of product sales, a matrix can show you a breakdown of Product Categories down the side (rows) and Years across the top (columns), with the total sales for each combination displayed neatly in the grid.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When Should You Use a Matrix?

A matrix is your go-to visual when you need to answer questions that involve multiple variables. It shines in scenarios where you want to compare data across several categories or time periods. Here are a few common use cases:

• Sales Performance Analysis: Displaying product sales broken down by store location (rows) and quarter (columns). You could even drill down further into product sub-categories within each store.
• Financial Reporting: Creating a profit and loss statement with account categories (e.g., Revenue, COGS, Expenses) as rows and months or quarters as columns.
• Website Analytics: Comparing website traffic from different sources (e.g., Google, Facebook, Direct) across different device types (Desktop, Mobile, Tablet).
• Human Resources Data: Analyzing employee headcount or performance ratings by department (rows) and comparing them year over year (columns).

Essentially, any time you find yourself wanting to create a "cross-tab" report to summarize large datasets, the matrix visual is the right tool for the job.

Step-by-Step: Creating Your First Matrix Visual

Let's build a matrix from scratch. For this example, we’ll use a simple sales dataset that includes fields for Product Category, Region, Order Date, and Sales Amount.

Step 1: Add the Matrix Visual to Your Report

First, open your Power BI report canvas. In the Visualizations pane on the right-hand side, find and click the Matrix icon. It looks like a grid. This will add a blank matrix placeholder to your canvas. Resize it as needed.

Step 2: Add Data to the Rows, Columns, and Values

With the blank matrix selected, you'll see three primary fields in the Visualizations pane under the visual icons: Rows, Columns, and Values.

This is where you tell the matrix how to structure your data:

• Rows: Drag the field you want to group your data by vertically. Let’s drag Product Category here.
• Columns: Drag the field you want to see displayed horizontally across the top. Let’s drag Region here.
• Values: Drag the numeric field you want to aggregate. This is what will fill the cells of your grid. Let's drag Sales Amount here. Power BI will automatically sum this value, but you can change the aggregation (e.g., to average, count, etc.) by clicking the small arrow next to the field name.

As soon as you drop these fields in, your matrix will come to life, showing total sales for each product category broken down by region.

Step 3: Build Hierarchies with Drill-Down Functionality

The real power of the matrix comes from its ability to handle hierarchies. Let’s say you also have a Product Sub-Category field in your data. You can create a drill-down experience for your users.

Simply drag the Product Sub-Category field into the Rows well, directly underneath the Product Category field. Now you’ll see small plus signs (+) next to your row headers. Clicking a plus sign will expand that category to reveal the sub-categories within it, complete with their own sales figures.

You can also create a hierarchy in the columns. For instance, if you had fields for Year and Quarter, you could add both to the Columns well to let users drill down from an annual view to a quarterly one.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing and Formatting Your Matrix

A basic matrix is useful, but a well-formatted matrix is much more impactful. Power BI offers extensive formatting options to make your data easier to read and interpret. Select your matrix, then click the Format your visual icon (it looks like a paintbrush) in the Visualizations pane.

Stepped Layout vs. Classic Table Layout

By default, matrices use a stepped layout, where sub-categories are indented underneath their parent category. This saves horizontal space. You can turn this off for a more traditional, flat table look.

Go to the Format your visual tab, expand the Row headers section, and toggle the Stepped layout switch. When it’s off, each field in the row hierarchy will get its own column.

Adding Subtotals and Grand Totals

Totals are essential for providing context. In the Format pane, you can find sections for Row subtotals, Column subtotals, and Grand total. Here, you can toggle them on or off, change their labels, and adjust their formatting to make them stand out.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Applying Conditional Formatting

Conditional formatting turns a grid of numbers into a clear visual story. It helps users instantly spot trends, outliers, and key data points. You’ll find the options under the Cell elements section in the Format pane.

1. Data Bars

Adding data bars shows a bar inside each cell, with the length of the bar corresponding to the cell's value. This makes it incredibly easy to compare values within a column. In Cell elements, select your values field (e.g., Sum of Sales Amount), and toggle Data bars on. You can customize the bar colors from there.

2. Color Scales (Heatmaps)

A color scale, or heatmap, colors the background of each cell based on its value. For instance, you could make low sales values red, mid-range values yellow, and high values green. Under Cell elements, turn on Background color. Power BI will create a default gradient, but you can click the option to set your own logic and colors.

3. Icons

Icons let you add KPIs or business-rule indicators to your matrix. For example, you could show a green up arrow for sales figures that meet a certain target and a red down arrow for those that don't. Turn on the Icons toggle and use the advanced controls to define the rules for which icon appears in each cell.

Tips and Best Practices for Effective Matrices

• Don't Over-Clutter: Just because you can add many levels of hierarchy doesn't mean you always should. Too many nested levels can make the matrix hard to navigate. Stick to what's necessary to answer the business question.
• Use Clear Naming: Ensure your column and row headers are intuitively named. If your data source has a field called cat_prod_name, rename it in Power BI to something readable like Product Category.
• Optimize for Performance: Matrices with an extremely high number of rows and columns can slow down your report. If you have thousands of unique values in your row or column fields, consider applying filters to show only the most relevant data.
• Sort Your Data Mindfully: By default, data is sorted alphabetically in the rows or chronologically in the columns. You can change this by clicking the ellipsis (...) on the visual and selecting a Sort by option. Sorting by your main value (e.g., highest to lowest sales) can make the most important information rise to the top.

Final Thoughts

You've now learned how to build and customize one of the most flexible visuals in Power BI. The matrix is a fundamental part of creating dynamic, summary-level reports that give your audience the ability to explore data on their own terms, drilling from a high-level overview down into the granular details.

While mastering traditional BI tools is a powerful skill, we know it often involves a steep learning curve and hours of manual setup. At Graphed , we simplify this entire process by letting you build dashboards and reports with plain English. Instead of manually clicking, dragging, and formatting, you can just ask, "Show me a matrix of sales by product category and region," and get a live, interactive visualization in seconds, freeing you up to focus on insights, not setup.