In general, the data that we load from the source might have some columns that may not required for the analysis purpose. In this article, we will show you, the steps required to Remove Columns from Tables in Power BI with example.
How to Remove Columns from Tables in Power BI
In order to remove unwanted columns from the existing tables, please click Edit Queries option under the Home tab.
Clicking Edit Queries option will open a new window called Power Query Editor.
- Queries: List of tables that are available.
- Display the Data (rows, and columns) present in the selected table.
- Properties: Selected table Name. You can use this section to rename the Table to more meaningful.
- Applied Steps: This will list out the steps that we undertake on this table.
TIP: You can select the required column (or Ctrl + Select Columns for multiple columns), and hit Delete button from your keyboard.
For the demonstration purpose, we will remove few columns from the DimProductCategory table.
Remove Columns from Tables in Power BI – Approach 1
Please select the Column that you want to remove. Next, right-click on it, and select the Remove option from the context menu
Now, you can see that the Product Category Alternative Key column is removed from the table. And you can see the same under Applied Steps section.
Remove Other Columns: Use this option to remove all the columns from the table except the selected columns.
For the demonstration purpose, I am selecting the Product Category Key, and Product category name. Next, right-click on it, and select the Remove Other Columns option from the context menu
As you can see, all the other columns are removed from category table.
If you want to undo the changed (or revert the changes) then go to the Applied Steps section, and remove the step as we shown below.
This will undo the steps
Remove Columns from Tables in Power BI – Approach 2
First select the Column that you want to delete, and then click Remove Columns option under the Home tab.
Reordering Columns of Power BI Tables
Drag the column, and place it as per your requirement. For the demonstration purpose, we are dragging the English product category Name from last position to first position.
You an see the Category name in first Position
Whatever the changes you made will not effect until you hit Apply. Let me hit Close & Apply option under the Home tab.
Please wait until the changes are made
And you can see that the product Category table has only two columns.
Thank You for Visiting Our Blog