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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Rgieltjes_Meyn
Helper III
Helper III

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

@Rgieltjes_Meyn 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

@Rgieltjes_Meyn 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!:
The Definitive Guide to Power Query (M)

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!

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

@Rgieltjes_Meyn 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler 

 

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

 

Rgieltjes_Meyn_0-1678703743804.png

 

@Rgieltjes_Meyn 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler ,

 

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

 

Thanks

@Rgieltjes_Meyn 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.