How to get measure's to show vertically in a table?

[rlupe]

Hi,

I have 13 Order Types which I want to show in a table, but vertically instead of each being their own column.

Each order type has their own column in my tables, so I have 13 seperate measures. I am just using sum formula, though my measures use 3 different tables. Usually when I use matrices it is all from the same table and no problem.

Is there a way to stack measures if they don't all share the same column/table? Maybe without a matrix grid? Below is how I am trying to view my data.

Order Type	Value	% To Total
Order Type 1	$985	3.3%
Order Type 2	$5,487	18.3%
Order Type 3	$23,512	78.4%

[Greg_Deckler · Accepted solution]

@rlupe Well, you can turn "Show on rows" in a matrix for Values | Options. The other approach would be to unpivot those rows in your data table in Power Query Editor and then you should only require a single measure and could use a table visual.

[rlupe]

Thank you this works! My % To Total column is instead a row under each order type but this fits my needs.