Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
alicek
Helper III
Helper III

Add meta-data static columns to a matrix on the left side of the matrix (not values)

Hi all, 

 

I would like add more than one column of row headres -- the first column would be project name, but then I would add another column that would show the project manager and/or status of the project. This would all be on the left side of the dividing line that divides the row headers from the values/columns. 

 

An old post referenced adding the fields to the Rows, but then turning off "stepped layout", but it was from 2023 and I no longer see anything like that in the Format pane. 

Any suggestions?

How it is now:

alicek_0-1745539527892.png
What I would like to be in the first two columns, instead of only project name:

alicek_1-1745539558220.png

 

Thanks all!

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

lbendlin_0-1745541823690.png

choose Tabular and then disable the Totals for the secondary row value

View solution in original post

v-pagayam-msft
Community Support
Community Support

Hi @alicek ,
Thank you @lbendlin for the helpful response!
As lbendlin suggested, switching the layout to Tabular (under Layout and style presets) is the way to show multiple row headers like Project Name and Status side by side in the Matrix. This replaces the old "Stepped layout" toggle. After setting the layout to Tabular, just turn off row subtotals for the second field to keep things clean. That should give you exactly the layout you are aiming for.

Hope this resolve your issue.If so,consider accepting it as solution.

Regards,
Pallavi.

View solution in original post

8 REPLIES 8
v-pagayam-msft
Community Support
Community Support

Hi @alicek ,
Thank you @lbendlin for the helpful response!
As lbendlin suggested, switching the layout to Tabular (under Layout and style presets) is the way to show multiple row headers like Project Name and Status side by side in the Matrix. This replaces the old "Stepped layout" toggle. After setting the layout to Tabular, just turn off row subtotals for the second field to keep things clean. That should give you exactly the layout you are aiming for.

Hope this resolve your issue.If so,consider accepting it as solution.

Regards,
Pallavi.

Thank you @v-pagayam-msft ! That worked!!

However, it doesn't appear to be able to sort by Project Stage, the other meta-data column I just added. No matter how I try to get it to sort, it won't. Any ideas?

alicek_0-1745608097688.png

 

lbendlin
Super User
Super User

lbendlin_0-1745541823690.png

choose Tabular and then disable the Totals for the secondary row value

It doesn't appear to be able to sort by Project Stage, the other meta-data column I just added. No matter how I try to get it to sort, it won't. Any ideas?

alicek_0-1745608097688.png

 

What is your expected sort order?

Normally, when you click on the title of a column with data type text, it auto-sorts alphabetically and a small black ticker arrow appears showing int he column header. 

That's what I expect here when I cllick on the Project Stage column. However, although the black ticker arrow appears, it remains sorted by Project Name (you can see from the screenshot that the stages (in progress, complete, cancelled) continue to be inter-mixed). 

You would need to change the hierarchy order of the columns for the sort to work that way.

Thank you so much!!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors