cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rprice124
Regular Visitor

Matrix - Stacked Vertical columns and rows

Hello i'm in need of some expert help with a Matrix, i'm trying to created a stacked matrix where the column heading is on top, then the value underneath for multiple columns rows.  I'm not sure if this is possible with a matrix but looking for any suggestions are greatly appreciated! 

 

2021-11-23_16-04-58.jpg

1 ACCEPTED SOLUTION

Hi @rprice124 ,

If your table looks like as below, you can try Unpivot Columns Function.

1.png

Transform your table to let it looks like as below.

2.png

Then create a matrix visual or multi-row card visual.

1.png

Turn off Category in multi-row card visual.

1.png

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
mahoneypat
Microsoft
Microsoft

You could try the Show on rows features of a matrix, or just use a Multi-card visual like below.

 

mahoneypat_0-1637704613382.png

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thanks for the response Pat, i tried both  and wasnt able to produce the results you were seeing, i'm still getting the results in column/value order like my orignal table? 

Hi @rprice124 ,

If your table looks like as below, you can try Unpivot Columns Function.

1.png

Transform your table to let it looks like as below.

2.png

Then create a matrix visual or multi-row card visual.

1.png

Turn off Category in multi-row card visual.

1.png

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!