Forum Discussion
Pivot or not?
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 ho...
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
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
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.
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