Pivot Columns

[jacobmk]

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

[v-chuncz-msft · Accepted solution]

@jacobmk,

You may use the Matrix visual. Drag Country to Rows, Month to Columns, and Ticket and Sales to Values.

[Anonymous]

Hi @jacobmk,

This is a useful article which explains it in detail:

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

Regards,

L.Meijdam