Forum Discussion
Arrange Row & Column in Matrix Visual
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.
5 Replies
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 Columns3) 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 accordingly10) Disable row subtotal from setting
I hope I answered your question!
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.
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
