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
Anonymous
Not applicable

2 or more columns in a single row in Matrix

vishnudutt_0-1693820284293.png

Pls help me, in figure out how to place Description and Stockcode in same level of hireracy in Matrix

5 REPLIES 5
Anonymous
Not applicable

I wan to see the total of Brand level as well , Is there any way I can combine both Columns( description and Stockcode) into Single Column .  Then I can show both of them simultaneously.

danextian
Super User
Super User

Hi @Anonymous ,

The closest you can get  to that is by disabling the Stepped Layout.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Anonymous
Not applicable

Is there any way I can combine both Columns( description and Stockcode) into Single Column . I think It might Work right?

You can concatenate them using ampersand "&" just like you would in Excel, CONCATENATE (accepts two columns only) or COMBINEVALUES (accepts a delimiter and more than two columns).





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
vicky_
Super User
Super User

This isn't exactly supported in the regular PowerBI matrix.
Two easiest ways i can think of:

first is to create a calculated column that combines Description and Stock Code, and any other columns you want on the same heirarchy level (maybe using CONCATENATE() function?)

Or you can turn off stepped layout in the formatting options

vicky__0-1693867637186.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors