Power BI Unpivot table option will convert selected columns into rows. In this article, we will show you, How to create an Unpivot table or how to convert pivot table into unpivot table in Power BI with an example.
How to create unpivot Table in Power BI
In order to create or convert pivot to unpivot 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 unpivot the columns 2005, 2006, 2006, and 2007.
There are a couple of ways to unpivot table in power bi
The First approach to unpivot table in Power BI
Please select the columns that you don’t want to unpivot or you want to keep them unchanged will open the context menu. Select Unpivot Other Columns option. This will unpivot all the columns except the selected ones.
Now you can see the unpivoted table
The second approach to unpivot table in Power BI
Please select the columns that you want to unpivot will open the context menu. Select Unpivot Only Selected Columns option. This will unpivot all the selected columns.
Now you can see the unpivoted table
The third approach to unpivot table in Power BI
In order to convert the pivot table into the unpivot table, go to Transform Tab. Under this tab, you can find the Unpivot Column button as shown below.
Use the drop-down list to unpivot the table. For the demonstration purpose, we selected the Product ID, and Name columns and then selected the Unpivot Other columns option.
Now you can see the unpivoted table.
We renamed the columns to more meaningful ones. Next, hit Close & Apply option under the Home tab to apply these changes.
From the below screenshot, you can see the unpivot columns
