Arrange Row & Column in Matrix Visual

[Anonymous]

Hi All,

I have Table A as picture below. How can I arrange those rows and column in Table A to the Matrix below. Anyone have any idea? I'm prefer to use measure instead of transform the table in Powerquery since I have couple of other column to make further calculation. Really appreciate your help.

[pratyashasamal]

Hi @Anonymous ,
First unpivot the loaded table and then create a matrix view on top of it .
To unPivot the table please follow these steps:-
https://databear.com/power-bi-pivot-and-unpivot-columns/
Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Uzi2019]

Hi @Anonymous 
I have taken your sample data.please do the following stepts in power query:
1) Select all the column except teacher ( select Class A, Class B, Class C, Score 1, Score 2, Score 3)
2) Go to Transform Tab then select Unpivot Columns

3) then duplicate the Attribute column like below

4) select the duplicate column and select split column option from tranform tab

5) select space as delimiter

6)you will see the below columns

7) select attribute copy 2 and remove it.

😎 Close and Apply

9) take Matrix visual and the columns accordingly

10) Disable row subtotal from setting

I hope I answered your question!

[Anonymous]

Is there anyway to do without using Power Query? I mean using measure. Because I need to use some of other column to make further calculation.

Thank you!

[Uzi2019]

Hi @Anonymous 
You can create duplicate table then you can pivot only one table. and on other table you can create calcuation.

I hope this would work for you.

[Anonymous]

example of the things that i would like to calculate/display further is to display rolling 12 month of the data (imagine there is a date table). I have try to pivot using powerquery but I cannot display rolling 12 month for the data