Power BI Pivot Table

Power BI pivot table option converts selected rows into columns. Let me 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

To create a Power BI pivot table or to convert unpivot to a pivot table, please click the Edit Queries option under the Home tab.

Power BI Pivot Table 1

Clicking Edit Queries option opens a new window called Power BI Power Query Editor.

In this example, we are going to pivot the calendar year column based on the order quantity.

Power BI Pivot Table 2

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.

Power BI Pivot Table 3

Clicking the pivot Column button opens the following window.

Power BI Pivot Table 4

Let me select the Order Quantity as the values column

Power BI Pivot Table 5

Next, we selected the Sum as the aggregate function value

Power BI Pivot Table 6

Now you can see the pivot table

Power BI Pivot Table 7

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.

Power BI Pivot Table 8

Let me select the Order Quantity column as the values column, and Sum as the aggregate function

Power BI Pivot Table 9

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.

Power BI Pivot Table 10

Next, hit the Close & Apply option under the Home tab to apply these changes.

Power BI Pivot Table 11

From the screenshot below, you can see the pivot columns.

Power BI Pivot Table 12

Comments are closed.