Power BI pivot table option will convert selected rows into columns. In this article, we will show you, How to create a pivot table or how to convert the unpivoted table into a pivot table in Power BI with an example.
How to create a Power BI Pivot Table
In order to create a Power BI pivot table or convert unpivot to a pivot table, please click Edit Queries option under the Home tab.
Clicking Edit Queries option will open a new window called Power Query Editor.
In this example, we are going to pivot the calendar year column based on the order quantity.
In order to convert the unpivot table into a pivot table, go to Transform Tab. Under this tab, you can find the pivot Column button as shown below.
Clicking the pivot Column button will open the following window.
Let me select the Order Quantity as the values column
Next, we selected Sum as the aggregate function value
Now you can see the pivot table
What if your table had more than one static column (a column that won’t change in the pivot process)? For this, we added one more column called Product Id to this table.
Let me select the Order Quantity column as the values column, and Sum as the aggregate function
Now you can see the Pivot table in Power BI. Remember, having more than one unchanged static column will not make any difference in creating a pivot table.
Next, hit Close & Apply option under the Home tab to apply these changes.
From the below screenshot, you can see the pivot columns