How to Use Matrix in Power BI

Tired of endlessly scrolling through flat tables that just list data? The Matrix visual in Power BI is a powerful tool designed to turn overwhelming datasets into structured, easy-to-read reports. It transforms raw numbers into interactive crosstab tables (think smarter, more flexible pivot tables) that you can drill into to find answers. This article walks you through everything you need to know to master the matrix, from building your first one to applying advanced formatting that makes your insights stand out.

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?

In Power BI, a matrix is a visual that displays data in a grid of rows and columns, similar to a pivot table in Microsoft Excel. What makes it so powerful is its ability to handle hierarchies, meaning you can group your data into different levels and let users drill down into the details. For example, you can show a summary of sales by product category, and with a single click, expand it to see sales by sub-category, then by individual product.

The standard "Table" visual in Power BI can only display data in a simple, two-dimensional format. The Matrix, however, lets you work with data across multiple dimensions in a more intuitive, nested layout. Its key advantages include:

• Hierarchical Display: Easily group and sub-group data in both rows and columns (e.g., Region > Country > City).
• Drill-Down and Drill-Up: Empower users to explore the data at a high level or dive deep into the fine-grained details themselves.
• Stepped Layout: A compact and clean formatting option that nests subcategories under their parent categories in a single column, making the report easier to read.
• Cross-Highlighting: Like all Power BI visuals, you can click on an item in a matrix to filter other visuals on the same report page.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Building Your First Power BI Matrix (Step-by-Step)

Let's create a matrix from scratch. For this example, we’ll use a typical sales dataset that includes fields like Product Category, Product Sub-Category, Sales Amount, Order Date, and Region. The process is straightforward and only takes a few steps.

1. Add the Matrix Visual to Your Report

First, open your Power BI Desktop report. In the Visualizations pane on the right-hand side, find the icon that looks like a small grid table. This is the Matrix visual. Click on it to add an empty matrix to your report canvas.

2. Populate the Matrix with Data

With your empty matrix selected, you’ll see three main fields (or "wells") in the Visualizations pane: Rows, Columns, and Values. This is where you'll drag your data fields to construct the report.

• Rows: This is for the categorical data you want to display down the left side of the matrix. Let’s start by dragging Product Category into this well.
• Columns: This is for the categories you want to display across the top. Drag the Region field here.
• Values: This well is for the numerical data you want to summarize. Drag your Sales Amount field here. Power BI will automatically aggregate it, typically as a sum.

Just like that, you have a basic matrix. It will show a grid with your product categories as rows, regions as columns, and the total sales for each intersection, along with the grand totals for both rows and columns.

Getting More from Your Matrix: Hierarchies and Drill-Down

The real magic of the matrix comes alive when you start using hierarchies. This functionality allows you to create rich, layered reports that users can navigate without leaving the page.

Creating Hierarchies in Rows and Columns

To create a hierarchy, you simply drag more fields underneath the existing ones in the Rows or Columns wells. Let’s expand our example:

1. Drag the Product Sub-Category field into the Rows well and place it directly under Product Category.
2. In our dataset, the Order Date field is automatically recognized as a date hierarchy. Let's drag it into the Columns well and place it under Region. Power BI will let you choose hierarchy levels like Year, Quarter, Month, and Day.

Your matrix now has multiple layers. By default, it will show a collapsed view with just the top-level categories (Product Category and Region).

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using the Drill-Down Features

Once you have a hierarchy, several icons will appear in the top-right corner of your matrix that let you control how users interact with the data.

• Plus/Minus Icons (+/-): Next to each row header with a hierarchy (like "Technology"), you'll see a plus icon. Clicking this expands only that specific item to show the next level of detail (e.g., showing just the sub-categories within Technology).
• Drill Down button (single ↓): This enables "click to drill" mode. Once active, clicking a top-level category (e.g., 'Accessories') will take you into that category, filtering the view to show only the sub-categories under Accessories. To go back up, use the drill-up (↑) icon.
• Expand All Down One Level button (double ↡): This will expand every single item in the entire hierarchy to the next level. Click it once, and every product category will expand to show its sub-categories.

These features turn your static report into an interactive exploration tool, allowing decision-makers to go from a high-level overview to granular details effortlessly.

Advanced Formatting for Clearer Insights

A well-formatted matrix makes the data much easier to interpret. Power BI's Format your visual pane (the paintbrush icon) gives you extensive control over the look and feel.

Stepped Layout vs. Classic Layout

Under the Row headers section, you'll find an option called Stepped layout. This is on by default and presents hierarchies with indentation, which is cleaner and saves horizontal space. If you turn it off, each level of the hierarchy gets its own column, more like a traditional pivot table. This can be useful if you're exporting data to Excel but is generally less readable on-screen.

Conditional Formatting

This is one of the most powerful features for highlighting key information. It lets you format a cell's background color, font color, or icon based on its value.

To apply it, select your matrix, go to the Format your visual pane, open up Cell elements, and select the value field (e.g., Sum of Sales Amount). Then, turn on one of the options:

• Background color: Use a color gradient to create a heatmap. For example, make low sales red, medium sales yellow, and high sales green. This instantly draws the eye to areas of high performance or concern.
• Data bars: This adds a small bar chart inside each cell, with the length of the bar representing the cell's value relative to others. It's a fantastic way to quickly compare values within a column.
• Icons: Apply business logic with simple visual cues. You could show a green checkmark for sales above target, a yellow exclamation point for sales that are close, and a red 'X' for sales far below target.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Totals and Subtotals

The matrix automatically calculates grand totals, but you have fine-grained control over subtotals. In the Format your visual pane, go to the Subtotals section. Here you can toggle row and column subtotals ON or OFF. You can even choose to show subtotals at the per-row-level or per-column-level, giving you precise control over your summary calculations.

Quick Tips and Best Practices

• Don’t Overdo a Good Thing: While you can add many levels to a hierarchy, more isn’t always better. A matrix with ten nested levels can become confusing to navigate. Aim for 2-4 levels for optimal readability.
• Prioritize Performance: Incredibly large matrices with thousands of rows and dozens of columns can slow down your report. If you're working with massive datasets, consider filtering your data down to what's most essential before bringing it into the matrix.
• Write Explicit DAX Measures: Although a simple Sum works fine, creating explicit measures using DAX (Data Analysis Expressions) is a best practice. Instead of dragging in the Sales Amount column, you can create a measure like Total Sales = SUM(Sales[Sales Amount]). This makes your formulas reusable and more manageable as your model grows.
• Toggle Values to Rows: Under the Values section of the formatting options, you can find a "Show on rows" switch. If you have multiple measures in the Values well (like Total Sales and Total Profit), this will transpose them to appear as rows under each category. It’s perfect for creating a line-item style report for easy comparison.

Final Thoughts

The matrix is a core visual in Power BI for anyone building reports with layered, dimensional data. By learning how to set up hierarchies, use drill-down features, and apply thoughtful conditional formatting, you can create professional dashboards that give users the power to find the answers they need, right when they need them.

While Power BI matrices are a fantastic tool for building detailed, structured reports, setting them up still requires you to manually arrange fields and fine-tune formatting. Sometimes, you just need a quick answer without all the clicks. We designed Graphed to bypass the build process entirely. By connecting your data sources, you can ask questions like "compare sales vs profit for each product sub-category in the UK" and instantly get an interactive visual in return. It’s designed to give your whole team the ability to get live insights from your data just by asking questions in a chat.