Forum Discussion
jacobmk
8 years agoRegular Visitor
Pivot Columns
Hi ,
I have a Dataset as below. Four columns are there in the dataset
I would like to transpose the column as below
How can we achieve in Power BI
Thanks
You may use the Matrix visual. Drag Country to Rows, Month to Columns, and Ticket and Sales to Values.
2 Replies
- AnonymousNot applicable
Hi jacobmk,
This is a useful article which explains it in detail:
http://radacad.com/pivot-and-unpivot-with-power-bi
Regards,
L.Meijdam
- v-chuncz-msftCommunity Support
You may use the Matrix visual. Drag Country to Rows, Month to Columns, and Ticket and Sales to Values.