Matrix - Stacked Vertical columns and rows

[rprice124]

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! 

[mahoneypat]

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

Pat

[rprice124]

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? 

[v-rzhou-msft · Accepted solution]

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 Zhou

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