Skip to main content

How to Rename a Field in One Power BI Visual

· 3 min read
Jagdish Kumawat
Founder @ Dewiride

Power BI names a summed column Sum of Amount in a visual. Rename for this visual changes the name one visual shows, without touching the model or any other visual. Here's how.

The example renames Sum of Amount to Amount in a table of expense claims (How to Add a Table to a Power BI Report).

Step 1: Open the Field's Menu​

In Editing mode, select the visual. In the Visualizations pane, find the field in its well, here Sum of Amount in Columns, and select the arrow next to it. Select Rename for this visual:

The Columns well with Expense, Sum of Amount, Category and ExpenseDate, and the field's menu with Remove field, Rename for this visual outlined in red, Move, Add a sparkline, Conditional formatting, Don't summarize, Sum ticked and Average

Step 2: Type the Name​

The field becomes a text box. Type the new name, Amount, and press Enter:

The Columns well with the second field being edited as Amount

Step 3: Check the Visual​

The table's header reads Amount:

The table with the headers Expense, Amount, Category and ExpenseDate, five claims and a Total of 293.70

In the Data pane and in every other visual, the column is still Amount of Expenses, summed as before; only this visual's label changed.

Common Mistakes​

MistakeWhat happensDo this instead
Renaming in each visual what should change everywhereEvery new visual shows the old nameRename the column in Power Query or the model
Selecting Don't summarize to lose Sum ofThe table lists every amount without a totalKeep Sum, rename the label
Renaming with no visual selectedThe well isn't shownSelect the visual first

Troubleshooting​

SymptomLikely causeFix
No Rename for this visualThe menu is the Data pane's, not the well'sUse the arrow on the field in the well
The old name is backThe field was removed and added againRename it again

FAQ​

Does this rename the column in the model?​

No. To rename it everywhere, rename it in Power Query (How to Rename a Column in Power Query).

Does it work for chart axes and card labels?​

Yes: any visual's field well has the same menu.

Conclusion​

Select the visual, open the field's menu in its well, choose Rename for this visual, type the name and press Enter. The example's Sum of Amount became Amount in one table.

Additional Resources​