Power BI – Pivot columns

Pivot on columns in Power BI means converting columns to rows. We will first get the data and then perform te pivot column operation.

Input File: Proft.xlsx
Output Saved as: Amit Pivoted Column.pbix

Click Get Data and select Excel Workbook. We have an Excel file named Profit.xlsx. Select and click Open to add it:

Open the Excel workbook on Power BI

Now, click Load or Transform Data. We will click Transform Data because it will directly take us to the Power Query Editor:

Tranform the data that is the excel workbook in Power BI

We’ll perform Pivot to get each column as an individual month i.e. the opposite. Therefore, click the Transform tab under the Power Query Editor. To perform the pivot, click the Pivot Column:

Pivot Column in Power BI

From here, select the Values Column and click Ok. The name and values columns are what we need. The name here is Month and the values Profit:

Set the Values Column for Pivot Column in Power BI

The pivoted result is now visible. Now, the rows are grouped by years. A separate column for each month can also be seen:

Pivot Column result visible in Power BI

Now, we have the Pivoted Column. On the right, in the Query Settings section, the changes are visible i.e. Pivoted Column under the APPLIED STEPS. If you want to delete, then right-click, and click Delete.

Press CTRL+S and save it:

Save the pivoted column in Power BI


If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.


For Videos, Join Our YouTube Channel: Join Now


Read More:

Power BI - Group rows
Power BI - Create custom columns
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment

Discover more from Studyopedia

Subscribe now to keep reading and get access to the full archive.

Continue reading