How to Format Matrix in Power BI

The matrix visual in Power BI is a workhorse for reporting, letting you display data in a way that feels a lot like a pivot table from Excel. But a default matrix can look cluttered and be difficult to read. This guide will walk you through the essential formatting options you need to transform your raw matrix into a clean, professional, and insightful report that’s easy for anyone to understand.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Matrix Visual in Power BI?

Before we jump into formatting, let's quickly touch on what a matrix is. Think of it as a more advanced version of the standard table visual. While a table displays data in simple rows and columns, a matrix allows you to group data by both rows and columns, creating a "cross-tab" or pivot-style view. This is perfect for summarizing data, like seeing sales figures broken down by product category (rows) and region (columns) simultaneously.

The key feature is its ability to handle hierarchies. You can "drill down" into your data, expanding a category like "Electronics" to see subcategories like "Laptops" and "Phones," giving your reports an interactive and layered feel.

Creating and Populating a Basic Matrix

To format a matrix, you first need one in your report. Creating it is straightforward:

1. In the Visualizations pane, click the Matrix icon to add it to your report canvas.
2. With the new matrix selected, drag and drop fields from the Data pane into the appropriate buckets:

Once populated, you’ll have a basic, unformatted matrix. Now, let’s make it look great.

Navigating the Format Pane

All formatting magic happens in the Format visual pane. First, make sure your matrix is selected on the canvas. Then, look for the paintbrush icon in the Visualizations pane. Clicking this opens a panel with two main tabs at the top: Visual and General.

• The Visual tab contains options specific to the matrix itself, like styles, grid lines, headers, values, and conditional formatting. This is where you'll spend most of your time.
• The General tab handles formatting for the container holding the visual, such as the title, background effects, and tooltips.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Core Formatting Options on the "Visual" Tab

This is where you can fundamentally change how your matrix looks and feels. Let's break down the most impactful sections.

Style Presets: The Quickest Way to Improve Your Matrix

If you need to make your matrix look better fast, start with Style presets. Located right at the top of the Visual tab, this dropdown offers pre-designed themes.

• None: The default, basic view.
• Minimal: A clean style with simple lines separating headers.
• Bold header: Makes your column and row headers stand out.
• Alternating rows: Shades every other row, making it much easier to follow data across wide matrices. This is a fan favorite for readability.
• Flashy rows: A more high-contrast version of alternating rows.

Applying a preset is a great first step, and you can still customize every element afterward.

Grid Lines: Creating Structure

The Grid section lets you control the lines that structure your matrix. You can independently manage horizontal and vertical grid lines, adjusting their color and thickness. Adding a light gray horizontal grid line can drastically improve readability without cluttering the view.

Column Headers, Row Headers, and Values

This is the heart of detailed formatting. You have three key sections here for controlling the text in your matrix: Column headers, Row headers, and Values. Each of these sections has a similar set of options:

• Text: Change the font family, font size, color, and style (bold, italic, underline).
• Background: Set a background color for the header or value cells.
• Alignment: Align the text to the left, center, or right. It's common practice to right-align numerical values and left-align text headers.

Pro Tip: Formatting Stepped Layout in Row Headers

When you have a hierarchy in your rows (e.g., Category > Subcategory), Power BI uses a "stepped layout" by default, indenting the child items. In the Row headers section, under the Layout options, you can adjust the Stepped layout indentation to increase or decrease the space, making the hierarchy more or less pronounced. You can also customize the +/- icons used for expanding and collapsing these rows.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Subtotals and Grand Total

Matrices automatically calculate subtotals for row or column hierarchies and a grand total for everything. This section lets you control their appearance and even turn them off if they aren't needed.

You can apply formatting (font, background color, etc.) to all row subtotals, all column subtotals, or the grand total independently. Under Per row level and Per column level, you can even toggle subtotals off for specific fields in your hierarchy. For example, if you have Country > City in your rows, you could display the country total but hide the city-level totals if they feel redundant.

Conditional Formatting: Bringing Your Data to Life

Conditional formatting is arguably the most powerful feature for making your matrix insightful at a glance. Instead of just showing numbers, it uses visual cues like colors, bars, and icons to highlight trends and outliers automatically.

To access it, go to the Cell elements section in the Visual format pane. Here, you'll see a list of the measures in your Values field. For each one, you can toggle different types of conditional formatting:

1. Background Color

This is essentially a heat map. Power BI colors the background of each cell based on its value. By default, it uses a color gradient where lower values are a light shade and higher values are a dark shade.

How to apply it:

1. Find your measure (e.g., Sales Amount) under Cell elements and turn Background color on.
2. Click the fx button next to the toggle to open the formatting options.
3. In the dialog box, you can define the logic. The "Gradient" format style is the default. You can change the colors for the minimum and maximum values, and even add a "diverging" color for the center value to create a two-color scale.

This immediately shows you where the "hottest" and "coldest" spots are in your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Data Bars

This option displays a small bar graph inside each cell, with the length of the bar representing the magnitude of the value. It's an excellent way to compare values within a single column without taking up extra space.

How to apply it:

1. Turn the Data bars toggle on for your desired measure.
2. Click the fx button to customize.
3. You can change the color of the positive and negative bars, choose to show the bar only (hiding the number), and set the direction.

3. Icons

Icons let you add a visual indicator next to your numbers based on a set of rules. This is perfect for KPIs where you want to show if a value is performing well, meeting expectations, or falling behind.

How to apply it:

1. Turn the Icons toggle on and click the fx button.
2. In the dialog box, you can choose an icon style (arrows, flags, traffic lights, etc.).
3. Next, you define the rules. For example, you could show a green up arrow if the value is greater than 80% (of a maximum), a yellow sideways arrow if it's between 50% and 80%, and a red down arrow if it's less than 50%. The rules can be based on percentages, absolute numbers, or even other measures in your model.

General Formatting Options

The "General" tab holds options that apply to the visual's container. The most important ones are:

• Title: A good, descriptive title is crucial. Here you can add title text, change its font, size, color, background, and alignment. Look for the Subtitle toggle if you want to add an extra line of clarification.
• Effects: This section lets you change the visual's overall background color, add a border, or apply a shadow to make it "pop" off the page. Setting a light gray, transparent background can help visuals blend nicely with a colored report background.
• Tooltips: Here you can customize the little pop-up box that appears when you hover over a cell. By default, it shows the data from that cell, but you can add more fields to provide extra context.

Final Thoughts

Properly formatting your matrix in Power BI is all about guiding your audience's attention toward what matters most. By moving beyond the defaults and using tools like style presets, well-defined grids, and powerful conditional formatting, you can turn a dense table of numbers into a clear, actionable story.

If you're looking for an even faster way to get answers from your data without getting lost in formatting panes, tools like Graphed are changing the game. We designed it so you can simply describe the dashboard you want in plain English - like "Show me a comparison of revenue vs. ad spend for my top campaigns" - and our AI builds it for you in seconds with your live data. You get the insights you need instantly, without spending hours configuring visuals.