How to change Columns & Values hierarchy in Matrix Visual ?

[Dixy]

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

[Vallirajap]

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!

[Dixy · Accepted solution]

I was able to change the data model and that got the data in required format.