Remove or Reorder Columns in Power BI

Generally, the data that we get from the source might have a few columns that may not require for the analysis purpose. Let me show you the steps required to Remove or Reorder Columns in Power BI with an example.

How to Remove or Reorder Columns in Power BI

Please click the Edit Queries option under the Home tab to reorder or remove unwanted columns from the existing Power BI tables.

Click Edit Queries button 1

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

From the below Power BI screenshot, you can see there are State codes and country codes, which are not required for the analysis purpose. So, let me remove those columns from this Geography table.

Query Editor 2

Remove Columns in Power BI

To remove Power BI columns, please select the Column you want to remove and right-click on it to open the context menu. Select the Remove option from the context menu

Remove or Reorder Columns in Power BI 3

Now, you can see that the State-Province Code column was removed from the table. And you can see the same under the Applied Steps section.

Remove or Reorder Columns in Power BI 4

Use Remove Other Columns option to remove all the columns from the table except the selected columns.

For the demonstration purpose, I am selecting City and selecting the Remove Other Columns option from the context menu.

Choose Remove Other columns option 5

As you can see, all the other columns except City were removed from the Geography table.

Remove or Reorder Columns in Power BI 6

Alternatively, you can click on the Remove Columns button under the Home Tab.

Remove or Reorder Columns in Power BI 7

Similarly, we removed the remaining unwanted columns.

Remove or Reorder Columns in Power BI 8

Reorder Columns in Power BI

Drag the required column and Drop at the position you want to place. For the Power BI reorder columns demonstration purpose, we are dragging Country Column to the second position (after geography Key).

Remove or Reorder Columns in Power BI 9

Now you can see the Country names in the second position

Remove or Reorder Columns in Power BI 10

Alternatively, right-click on the column name that you want to move will open the context menu. Please select the Move and then select the Right, Left, To End, or To Beginning option

Choose Move Right option 11

Now you can see the State in the third position. Next, hit the Close & Apply option under the Home tab to apply these changes.

Remove or Reorder Columns in Power BI 12

Please wait until the changes are applied.

Apply Query Changes 13

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.