Change headers of a matrix to rows

[Anonymous]

Hello everyone,

I am working in a report of sales and stock of our clients.

I am trying to replicate a table that I made in excel in power BI

I am using a Matrix to do that but I does not the result I need

As you can see, below the name of the month appear the names of the columns of the information I am using but I need the as the name of the rows like in the first picture. 

Hope you can help me. 

Best regards. 

[v-joesh-msft]

Hi @Anonymous ,

Drag the column of the field you want to display to 'Rows' and the result is as follows:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETLjvT2l1yJAqlTkAe64O-8BHPnOkNmmW2f-pkmQqd9sbA?e=THYzaU

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

you can try by changing header of matrix to rows..