Pivot and Unpivot

[pavan1]

Hi All,

Any one have idea on implementing pivot and unpivot using Power BI Desktop without power Query.

Regards,

J Pavan

[Eric_Zhang]

@pavan1

AKAIK,  there's no more elegant way, implementing Pivot and Unpivot with Power Query is pretty straightfoward, may I know why you don't like Power Query?

[pavan1]

Hi Vzhan,

I don't seen  power query tab option for writing using power bi Desktop.Coud you please give guidance or steps how can we perform pivot or unpivot using desktop with some exampe,So  that will be helpful to me.

Thanks&Regards,

J Pavankumar.

[Eric_Zhang · Accepted solution]

@pavan1

You can go to the query editor window by clicking "Edit Queries".

Check this article Pivot and Unpivot with Power BI.