Pivot or not?

[Anonymous]

Hi,

Im having a issue with transforming my table. I have made a small example of the current state(left table) and the state i want it to be eventually(right table). But i just cant figure out how to make it work

Can someone please help me out with this?

Gr,Bas

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,
Dale

[MFelix]

Hi @Anonymous,

Use the matrix visualization to setup this look.

Place X on the rows, Y on the Columns and then X on values and select the summarization as count.

Regards.

MFelix

[Anonymous]

Thanks for the reply, this does work!

However i need it to change in the data as well, so i can put some measures over it. I want to be able to filter some row's of the table.

[stretcharm · Accepted solution]

Try the Pivot and Unpivot options in the Query Editor to get data in the correct shape.

http://radacad.com/pivot-and-unpivot-with-power-bi