How to Remove or Reorder Columns in Power BI08-07-2019 0 Comment(s)
Clicking Edit Queries option will open a new window called Power Query Editor.
From the below screenshot you can see there are State codes, country codes, which are not required for the analysis purpose. So, let me remove those columns from this Geography table
Remove Columns in Power BI
Please select the Column that you want to remove and right-click on it will open the context menu. Select the Remove option from the context menu.Now, you can see that the State-Province Code column is removed from the table. And you can see the same under Applied Steps section.
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 selected the Remove Other Columns option from the context menu
No Comments to Show