Forum Discussion
Arranging measure, calculated measure as rows in Matrix table
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?
Hello Anonymous
In the formatting of the matrix visual, under Values you can turn on "Show on rows".
2 Replies
- jdbuchanan71
Super User
Hello Anonymous
In the formatting of the matrix visual, under Values you can turn on "Show on rows".