Forum Discussion
Arrange Row & Column in Matrix Visual
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!
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!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.
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