6 Various Power BI Matrix Multiple Columns Examples

In this article, we will learn about the Power BI matrix multiple columns and the Power BI matrix multiple column headers.

Additionally, we will cover some topics listed below:

  • Power BI matrix multiple column grouping
  • Power BI matrix multiple columns in row
  • Power BI matrix multiple columns sort
  • Power BI matrix multiple columns side by side

Power BI Matrix with Multiple Columns

Here, we learn how to display the matrix visual with Multiple columns in Power BI.

Scenario:

Imagine you’re the HR manager at a manufacturing company and want to analyze employee performance across different departments. You have data on employee names, departments, sales figures achieved, and customer satisfaction ratings.

A Power BI matrix with multiple columns can help you visualize this data effectively.

According to this scenario, we have a SharePoint list named Employee Performance that contains the following columns with various data types:

ColumnsData Types
DepatmentSingle line of text
Employee NameSingle line of text
Sales AmountCurrency
Customer Satisfaction RatingsNumber
power bi matrix multiple columns

1. Open Power BI Desktop and load the above SharePoint List in Power BI Desktop. Then, you can see the data presented in the Data pane.

power bi matrix with multiple columns

2. Under the Home tab, click “Visual gallery,” then click Matix Visual.

matrix in power bi with multiple columns

3. Drag the Employee Name field to the Rows section. This will create individual columns for each employee. Then, drag the Department, Sales Amount, and Customer Satisfaction Rating fields to the Value section.

power bi matrix visual multiple columns

This is how we can display the matrix visual with Multiple columns in Power BI.

See also  Bookmarks in Power BI | Create Power BI Bookmarks

Power BI Matrix Multiple Column Headers

Let’s see how we can format the matrix with multiple column headers in Power BI.

Now, follow the steps below to format multiple-column headers:

I hope you have already created a matrix with multiple columns in Power BI.

1. Select the matrix visual, click the Format option, and the Format pane will open. Expand the Column headers section here.

power bi matrix multiple column headers


2. Here, you can change the font family, font size, text color, background color, header alignment, and title alignment.

power bi matrix two column headers

3. In the screenshot below, you can see the font size is set to 17, the text color is white, and the background color is black. You can format these settings as per your requirements.

Power Bi matrix multiple columns headers example

This is how we can format the matrix multiple-column headers in Power BI.

Power BI Matrix Multiple Column Grouping

Imagine you’re a website manager for a news organization. You want to understand how website traffic varies by device type (desktop, mobile, tablet) and throughout different times of the day. A Power BI matrix with multiple-column groupings can help visualize these trends effectively.

According to this scenario, we have a dataset in Power BI. Please check the screenshot below.

power bi matrix column grouping

Now, under the Home tab, click “Visual gallery,” then click Matix Visual.

group columns in power bi matrix

In the Power BI matrix, drag the “Time of Day” field in the Rows, the “Device Type” field in the Columns, and the “Number of Visitors” field in the Values section.

power bi group columns in matrix

Then, our matrix visual looks like the screenshot below.

Grouping Matrix visual

Here, you can see it’s divided into three groups (desktop, mobile, tablet), but I want only two (Large Screens, Small Screens). Now, follow the steps below to do this:

See also  How to duplicate multiple columns using Power Query

Now, right-click the “Device Type” field and select “New group”.

power bi columns in matrix group

In the Groups window that opens, select “Desktop,” then click “Group.”

Power BI Matrix Multiple Column Grouping

Then, rename “Desktop” as “Large Screens” and then group “Mobile” and “Tablet” together. Rename this group as “Small Screens”. After that, click OK.

Power BI Matrix Multiple Column Group

After that, our matrix visual looks like the screenshot below.

group columns in power bi matrix visual

Power BI Matrix Multiple Columns in Row

Imagine you’re analyzing sales data. You want to see side-by-side comparisons of sales figures for different product categories (e.g., Electronics, Clothing) across various regions (e.g., North, South).

A standard matrix might only show categories as rows or columns, but you’d like to have both categories and regions stacked as rows for a more compact and visually appealing presentation.

According to this scenario, I already loaded a dataset in Power BI. Please check the screenshot below.

power bi matrix two row headers

Now follow the below steps to do this:

Now, under the Home tab, click “Visual gallery,” then click Matix Visual. Drag Category and Region into the Rows section and Sales into the Values section.

power bi matrix multiple rows side by side

Select the matrix visual, go to the Format pane, expand the Layout section, and under Style presets, select Layout as Tabular.

power bi matrix measures in rows and columns

Then, in the matrix visual, click Expand all down one leave in hierarchy.

power bi matrix multiple rows without hierarchy

After that, our matrix visual looks like the screenshot below.

Power BI Matrix Multiple Columns in Row

This way, you can create a Power BI matrix with multiple columns in a row.

Power BI Matrix Multiple Columns Sort

Now, we see how to sort multiple columns in the Power BI matrix visual.

Unfortunately, Power BI matrices don’t natively support sorting by multiple columns in the rows.

See also  How to Create Date Hierarchy in Power BI? [With Examples]

You can only sort one column at a time. To do this, follow the steps below:

Select the matrix visual, then click the three dots in the top-right corner. Choose Sort ascending or Sort descending. After that, expand Sort by and choose the column you want to sort.

Power BI Matrix Multiple Columns Sort

Power BI Matrix Multiple Columns Side By Side

In this example, we see how we can display the Power BI matrix in multiple columns side by side.

To do this, we have a dataset named Sample Sales Data. Please check the screenshot below.

power bi matrix multiple column side by side

Under the Home tab, click “Visual gallery,” then click Matrix Visual. Drag “Product Name” into the Rows section, and drag “Category,” “Region,” and “Sales” into the Values section.

power bi matrix column side by side

This way, you can display the Power BI matrix in multiple columns side by side.

Moreover, you may also like:

In this article, we covered the Power BI matrix with multiple columns and multiple column headers, including topics such as grouping multiple columns, displaying multiple columns in rows, sorting multiple columns, and placing multiple columns side by side.

>