0
0
Power BIbi_tool~5 mins

Column operations (rename, remove, reorder) in Power BI - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
This feature helps you change your table columns by renaming them, removing ones you don't need, or changing their order. It makes your data cleaner and easier to understand in reports.
When your data has unclear column names that need to be more descriptive for your team.
When you want to hide columns that are not useful for your analysis to reduce clutter.
When you want to arrange columns in a logical order for better report presentation.
When you import data with extra columns that you don't want to include in your visuals.
When you prepare data for sharing and want to simplify the table structure.
Steps
Step 1: Open
- Power Query Editor
The data preview window shows your table with all columns visible
Step 2: Right-click
- the column header you want to rename
A menu appears with options including Rename
💡 You can also double-click the column header to rename it
Step 3: Select
- Rename from the right-click menu
The column header becomes editable
💡 Type the new name and press Enter to save
Step 4: Right-click
- the column header you want to remove
A menu appears with the Remove option
Step 5: Click
- Remove
The selected column disappears from the table preview
Step 6: Click and drag
- a column header to a new position
The column moves to the new location in the table preview
💡 Release the mouse button to drop the column in place
Step 7: Click
- Close & Apply button
Changes save and apply to your Power BI report
Before vs After
Before
Table shows columns: ID, Sales, Region, ExtraInfo, Date in that order
After
Table shows columns: Date, Region, Total Sales, ID with ExtraInfo removed
Settings Reference
Rename Column
📍 Right-click menu on column header in Power Query Editor
Change the column name to something more meaningful
Default: Original column name
Remove Column
📍 Right-click menu on column header in Power Query Editor
Delete columns that are not needed in the data model
Default: Column remains
Reorder Columns
📍 Drag and drop column headers in Power Query Editor
Arrange columns in a preferred order for easier viewing
Default: Original column order
Common Mistakes
Trying to rename or remove columns directly in the report view
Column structure changes must be done in Power Query Editor, not in report view
Open Power Query Editor to rename, remove, or reorder columns
Removing columns without checking if they are used in visuals
Removing columns used in visuals causes errors or broken reports
Verify column usage before removing to avoid breaking reports
Not clicking Close & Apply after making changes
Changes stay only in Power Query Editor and do not reflect in the report
Always click Close & Apply to save and apply changes
Summary
You can rename, remove, and reorder columns in Power Query Editor to clean your data.
These changes help make your reports clearer and easier to use.
Remember to apply changes by clicking Close & Apply to update your report.