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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Have multiple rows in my matrix

Hi,

 

I currently have the following problem. I want to have 2 columns set as rows in my matrix. I want to have item no. and the description of the item number. I have added the 2 columns into rows but it displays with a + button shown on the picture below. I want item and the description next to each other as different collums. 

 

I must use matrix, can't use table!

 

Can someone help me?

 

Rgieltjes_Meyn_0-1678702604153.png

Rgieltjes_Meyn_1-1678702696905.png

 

 

2 ACCEPTED SOLUTIONS

@Anonymous That toggle is right above the Stepped layout toggle. You can turn it off.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

@Anonymous You have to toggle off Row subtotals I believe. It's 2 cards down from the Row headers card.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
AlexanderPrime
Solution Supplier
Solution Supplier

Would recommend making a custom column that concats the Item and Description into a single value then you can use that as your row descriptor. 

 

Unfortunately the matrix visual is somewhat limited in it's design. 


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!
Anonymous
Not applicable

Hi Alexander, 

 

Thanks for your reply. This isn't possible beceause this will cause trouble when i am exporting this into excel. Need the the two columns seperate.

Greg_Deckler
Super User
Super User

@Anonymous Turn off Stepped layout:

Greg_Deckler_0-1678703183323.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 

 

It shows like this now. Is it also possible to remove the 'total'?

 

Rgieltjes_Meyn_0-1678703743804.png

 

@Anonymous You have to toggle off Row subtotals I believe. It's 2 cards down from the Row headers card.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi @Greg_Deckler ,

 

This helped a lot. Is it possible to remove the + button? Or is that something that can't be removed?

 

Thanks

@Anonymous That toggle is right above the Stepped layout toggle. You can turn it off.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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