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

Dashboard Mode - Column operations (rename, remove, reorder)

Goal

Understand how to rename, remove, and reorder columns in Power BI to prepare data for analysis.

Sample Data

OrderID	Product	Category	Quantity	Price	Region
1001	Notebook	Stationery	5	2.5	East
1002	Pen	Stationery	10	1.2	West
1003	Desk Chair	Furniture	2	45	East
1004	Monitor	Electronics	1	150	North
1005	Desk Lamp	Electronics	3	20	South

Dashboard Components

• KPI Card: Total Sales Amount
  Formula: Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Price])
  Result: 5*2.5 + 10*1.2 + 2*45 + 1*150 + 3*20 = 12.5 + 12 + 90 + 150 + 60 = 324.5
• Table Visual: Original Columns
  Shows all columns as in sample data.
• Table Visual: After Rename and Remove
  Columns: Order Number (renamed from OrderID), Product, Quantity, Sales Region (renamed from Region).
  Removed columns: Category, Price.
• Table Visual: After Reorder
  Columns reordered as: Sales Region, Order Number, Product, Quantity.

Dashboard Layout

+----------------------+---------------------------+
|      KPI Card        |      Table: Original       |
|  Total Sales Amount  |       Columns Display      |
+----------------------+---------------------------+
|   Table: After Rename and Remove                |
+------------------------------------------------+
|           Table: After Reorder                  |
+------------------------------------------------+

Interactivity

Filters on Sales Region or Product update all tables and the KPI card to show filtered data. Renaming and reordering columns do not affect filtering but improve readability and layout.

Self Check

If you add a filter for Sales Region = East, which components update and what data do they show?

• KPI Card: Total Sales recalculates only for East region: (Notebook 5*2.5=12.5) + (Desk Chair 2*45=90) = 102.5
• Table Visuals: Show only rows where Sales Region is East (Order 1001 and 1003).

Key Result

Dashboard showing how to rename, remove, and reorder columns with sales data and total sales calculation.