Forum Discussion
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!
Hi rprice124 ,
If your table looks like as below, you can try Unpivot Columns Function.
Transform your table to let it looks like as below.
Then create a matrix visual or multi-row card visual.
Turn off Category in multi-row card visual.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- mahoneypat
Microsoft Employee
You could try the Show on rows features of a matrix, or just use a Multi-card visual like below.
Pat
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.
Transform your table to let it looks like as below.
Then create a matrix visual or multi-row card visual.
Turn off Category in multi-row card visual.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
