Arranging measure, calculated measure as rows in Matrix table

[Anonymous]

Hi,

I have a table that contains Region,Sales,Profit and I have calculated Profit% which is a measure.

What I could see like this,

Expected Result:

I tried to Unpivot the data in edit queries, but as profit% is a calculated measure which doens't show in the data in edit queries.

Is there any way to achieve the expected result above?

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

In the formatting of the matrix visual, under Values you can turn on "Show on rows".

[Anonymous]

Hello @jdbuchanan71 

Thank you for the solution.