Forum Discussion
How to change Columns & Values hierarchy in Matrix Visual ?
In my Matrix Visual I am getting the data like following - is it possible to change it as shown in my table below where 1st level classification is Section and then Group?
Current State :
Desired Result :
Data :
| Attribute | DarkLive | Section 1 | Section 2 | Section 3 | Group |
| B | 27 | 6 | 1 | Group1 | |
| B_Dark | Dark | 27 | 6 | 1 | Group1 |
| B_Live | Live | 0 | 0 | 0 | Group1 |
| B | 22 | 125 | 26 | Group2 | |
| B_Dark | Dark | 22 | 125 | 26 | Group2 |
| B_Live | Live | 0 | 0 | 0 | Group2 |
| A | 140 | 104 | 25 | Group1 | |
| A_Dark | Dark | 140 | 102 | 25 | Group1 |
| A_Live | Live | 0 | 2 | 0 | Group1 |
| A | 93 | 131 | 18 | Group2 | |
| A_Dark | Dark | 93 | 131 | 18 | Group2 |
| A_Live | Live | 0 | 0 | 0 | Group2 |
I was able to change the data model and that got the data in required format.
2 Replies
I was able to change the data model and that got the data in required format.
Hii Dixy,
Using a power query editor to achieve this one
Select Transform Date -> In the power query editor, select the section 1, section 2, and section 3 columns, and select the unpivot columns in the Transform pane. Now the data is like below.Select close and apply to upload the data.
Then choose the matrix table visual.
1. Row field: choose Attributes column
2. Column field: first select the section column; next select the group column.
3. Values filed: select the value column.
Now the matrix table is displayed below as per your need.
I hope it is helpful, Accept it as Solution to help other members find it. Appreciate your Kudos!
