Skip to main content
Power BIPowerBI tutorials

Override pivot table in Power BI

Power BIPowerBI tutorials

Override pivot table in Power BI

The Unpivot table option in Power BI converts selected columns to rows. Let's see how to create Unpivot table or how to convert pivot table to Unpivot table in Power BI with an example.

How to create a table without divisions in Power BI

To create or convert a pivot table to a table without divisions, click the Edit queries option under the Home tongue.

unpivot-table-in-power-bi-1-9530353

By clicking on the Edit queries The option opens a new window called Power BI Power Query Editor.

In this Unpivot Table example, we are going to univot columns 2005, 2006, 2006, and 2007.

unpivot-table-in-power-bi-2-4811171

There are a couple of ways to unlink the table

The first approach to unlinking tables in Power BI

Select the columns that you do not want to unlink or if you want to keep them unchanged, the context menu will open. Select the Remove other columns option. This triggers all columns except the selected ones.

unpivot-table-in-power-bi-3-6523457

Now you can see the table without a pivot.

unpivot-table-in-power-bi-4-5106609

The second approach to unlinking tables in Power BI

Select the columns you want to unlink to open the context menu. Please select Drop only selected columns option. This unwraps all the selected columns.

unpivot-table-in-power-bi-5-2341455

Now you can see the table without a pivot.

unpivot-table-in-power-bi-6-9335172

The third approach to unlinking tables in Power BI

To convert the pivot table to the table without divisions, go to Transform Tongue. In this tab, you can find the Remove column pivot button as shown below.

unpivot-table-in-power-bi-7-6802205

Use the drop-down list to unlink the table. For the purpose of demonstrating the Unpivot Table, we select the Product ID and Name columns, and then select the Remove other columns option.

unpivot-table-in-power-bi-8-4068059

Now you can see the table without divisions.

unpivot-table-in-power-bi-9-2815649

We change the name of the columns to more meaningful ones. Then press the Close and apply option under the Home tab to apply these changes.

unpivot-table-in-power-bi-10-2889960

In the screenshot below, you can see the columns without divisions on the right side.

unpivot-table-in-power-bi-11-6555115

The Unpivot table option in Power BI converts selected columns to rows. Let's see how to create Unpivot table or how to convert pivot table to Unpivot table in Power BI with an example.

How to create a table without divisions in Power BI

To create or convert a pivot table to a table without divisions, click the Edit queries option under the Home tongue.

unpivot-table-in-power-bi-1-9530353

By clicking on the Edit queries The option opens a new window called Power BI Power Query Editor.

In this Unpivot Table example, we are going to univot columns 2005, 2006, 2006, and 2007.

unpivot-table-in-power-bi-2-4811171

There are a couple of ways to unlink the table

The first approach to unlinking tables in Power BI

Select the columns that you do not want to unlink or if you want to keep them unchanged, the context menu will open. Select the Remove other columns option. This triggers all columns except the selected ones.

unpivot-table-in-power-bi-3-6523457

Now you can see the table without a pivot.

unpivot-table-in-power-bi-4-5106609

The second approach to unlinking tables in Power BI

Select the columns you want to unlink to open the context menu. Please select Drop only selected columns option. This unwraps all the selected columns.

unpivot-table-in-power-bi-5-2341455

Now you can see the table without a pivot.

unpivot-table-in-power-bi-6-9335172

The third approach to unlinking tables in Power BI

To convert the pivot table to the table without divisions, go to Transform Tongue. In this tab, you can find the Remove column pivot button as shown below.

unpivot-table-in-power-bi-7-6802205

Use the drop-down list to unlink the table. For the purpose of demonstrating the Unpivot Table, we select the Product ID and Name columns, and then select the Remove other columns option.

unpivot-table-in-power-bi-8-9974124

Now you can see the table without divisions.

unpivot-table-in-power-bi-9-1396796

We change the name of the columns to more meaningful ones. Then press the Close and apply option under the Home tab to apply these changes.

unpivot-table-in-power-bi-10-5970819

In the screenshot below, you can see the columns without divisions on the right side.

unpivot-table-in-power-bi-11-1879167
error: Attention: Protected content.