How to Show Multiple Columns Matrix in Power BI

Trying to make your Power BI matrix behave more like a traditional spreadsheet by showing multiple, distinct columns can sometimes feel like a puzzle. You know the data is there, but getting it to line up side-by-side instead of in a nested hierarchy isn't immediately obvious. This article will walk you through several methods to display multiple columns in a Power BI matrix, from the most straightforward toggle switch to more advanced data modeling techniques.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Power BI Matrix Visual?

Before we jump into the "how," let's quickly clarify what the matrix visual is and why you'd use it. Think of the matrix as Power BI's version of a pivot table from Excel. It's incredibly useful for summarizing data in a grid format, allowing you to group information by rows and columns with aggregated values in the middle. While a simple Table visual just shows rows of data, the Matrix lets you pivot and analyze your data from different angles.

Its primary strengths include:

• Hierarchical Display: You can create nested rows or columns, allowing users to drill down into more granular levels of detail (e.g., Year > Quarter > Month).
• Cross-Tabulation: It displays relationships between two or more different variables, making it perfect for things like seeing sales by region (rows) and product category (columns).
• Summarized Values: The values within the matrix are aggregated (sum, average, count, etc.), giving you a high-level view of performance.

The challenge often arises when you want to display multiple attributes for a single row item, much like you would in a standard report. For example, for each customer, you might want to see columns for their email address, city, and first purchase date, all on the same level. Let's look at how to achieve that.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Turn Off Stepped Layout for Side-by-Side Columns

This is the most common solution and the one that helps most people achieve that familiar, tabular look. By default, when you add multiple fields to the "Rows" field well in a matrix, Power BI creates a "stepped layout." This means each subsequent field is indented under the previous one, creating a nested tree structure. To turn this into side-by-side columns, you just need to flip a switch in the formatting options.

Step-by-Step Instructions

1. Build Your Basic Matrix: Select the Matrix visual from the Visualizations pane. Drag the fields you want to display as your main rows into the 'Rows' bucket. For example, let's use Country, then City, and then Customer Name.
2. Add Your Values: Drag a measure or a numeric field you want to summarize, like Total Sales, into the 'Values' bucket. At this point, you'll see a nested, stepped layout.
3. Navigate to Formatting Options: With the matrix selected, click on the paintbrush icon ('Format your visual') in the Visualizations pane.
4. Find Row Headers: Expand the 'Row headers' section in the format menu. This is where you can control the appearance of your row labels.
5. Turn Off Stepped Layout: Inside 'Row headers,' look for a toggle switch named 'Stepped layout.' Click it to turn it off.

Immediately, you will see your matrix transform. Each field from the 'Rows' bucket will now occupy its own distinct column, lining up side-by-side exactly like a standard table.

Example view (Stepped Layout OFF):

You'll now see discrete columns: one for Country, one for City, and one for Customer Name.

This is by far the quickest way to get the spreadsheet-style layout most users are looking for. You still retain the ability to use the +/- icons to expand and collapse parent levels (like Country), but the visual presentation is much cleaner for reports that require multiple descriptive columns.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Adding Multiple Measures to the 'Values' Field

Another way to interpret "multiple columns" is having more than one calculated value for your row categories. For instance, alongside 'Total Sales', you might want to see 'Total Profit', 'Units Sold', and 'Profit Margin' as separate columns.

Power BI makes this incredibly straightforward.

Step-by-Step Instructions

1. Start with Your Matrix: Set up your matrix with the desired fields in the 'Rows' and 'Columns' buckets. Let's say you have Product Category in 'Rows'.
2. Drag Multiple Measures to 'Values': Go to your 'Data' pane and find the measures or numeric fields you want to show. Drag each one into the 'Values' field well one by one.
3. When you have nothing in the "Columns" bucket, Power BI will automatically display each item from the 'Values' field well as a new column in your matrix. If you have a field in the "Columns" bucket (e.g., Year), then Power BI will create a column group, nesting each of your values (Sales, Profit) under each year.

You can control how these values appear by going to the 'Format your visual' pane, selecting 'Values', and finding the option 'Switch values to rows'. Sometimes, displaying values as rows instead of columns can make a cluttered report easier to read, though it's typically kept off for a standard column view.

Method 3: Pivot Data in Power Query for Dynamic Columns

Sometimes your data isn't structured in a way that lets you just drag and drop fields. This advanced method is for situations when the column headers themselves are currently stored as values in a single column.

Imagine you have data structured like this from a survey or a product attributes log:

Your goal is to have a matrix with a column for 'Color' and another for 'Size'. You need to reshape your data. This is done in the Power Query Editor.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions

1. Open Power Query: From the 'Home' ribbon in Power BI Desktop, click on 'Transform data.'
2. Select the Key Columns: In the Power Query Editor, find and select the column that contains the names of your new desired columns (in our example, an Attribute Type column).
3. Find the Pivot Column Tool: With that column selected, navigate to the 'Transform' tab in the ribbon. Click the 'Pivot Column' button.
4. Configure the Pivot: A dialog box will appear.
5. Click OK and Apply: After clicking OK, Power Query will pivot the table, transforming the rows into columns. Your data will now look like this:

Now, just click 'Close & Apply' in the home tab to load this reshaped data back into your Power BI model. You can then drag 'ProductID', 'Color', and 'Size' into a new matrix to display them as distinct columns.

Final Formatting Tips

Once you've set up your columns, remember to refine the matrix for clarity:

• Adjust Column Widths: Hover over the column borders in the header to resize them, ensuring all your data is readable.
• Format Headers: Use the format pane to change fonts, colors, and headers to make your report clear and professional.
• Use Conditional Formatting: Make important data points pop by adding background colors, data bars, or icons to your value columns based on their performance.

Final Thoughts

The Power BI matrix is a highly flexible tool once you learn its formatting rules. Whether you need side-by-side descriptive attributes by turning off the stepped layout, multiple value columns for different KPIs, or need to reshape your data to create dynamic pivoted columns, there is a way to create the view you need.

While building visually appealing and functional reports is rewarding, we know that the manual process of connecting data, reshaping tables, and configuring visuals can take hours away from analyzing the results themselves. At Graphed, we automate this entire workflow. Instead of clicking through menus, you can simply describe the report you want in plain English - like "create a report showing total sales and profit by customer country and city for the last quarter" - and instantly get a live, interactive dashboard, giving you your time back to focus on insights, not setup.