cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pbuser
Helper IV
Helper IV

Rename column headers in a table

Any ways to rename column headers in the TABLE visual ? The header is default to be the column/measure name. But I need to change to a different name without needing to change the column/measure name.

1 ACCEPTED SOLUTION

Hi,

 

If you change to Format pane in the Visualizations Pane you will find a tab called title. Enable it to type and format your title for your visual.

 

Skærmbillede 2016-06-14 kl. 07.23.17.png

/sdjensen

View solution in original post

9 REPLIES 9
efglynn
Advocate IV
Advocate IV

This is marked "Solved" but I disagree.

 

The name of a data field from a DBA in many cases is not the name wanted in the display of a table column header for non-technical people.  While it's nice when the labels in a report match the data, there needs to be a better way to make a table "better" by using a more meaningful column header.

MRussett
Advocate I
Advocate I

I see answers for changing a "Chart Title"... and also the Data Column Name... but the user is asking if there is a way to rename the column heading in a table vizulization.  For example, in my shipment data I do a unique count of the "Shipment ID" to determine what I would like to call "Shipment Volume" or in some cases just "Volume".   Instead PowerBI forces this column heading to be called "Count of Shipment ID" which is taking up a lot of horizontal space in my table for a column with data that is typically 1-6 in length.  Tableau has this feature which they call "Aliases".   Would be great to see this in PowerBI.

 

Hi,

I am also interested to see a solution for changing "Name of Column" and also how can i change the width of the Column Headers Width.

 

Many thanks

Baskar
Resident Rockstar
Resident Rockstar

Hi Pbuser,

 

Sorry ,  user question is like , how to change the column name in table so only i suggest these steps.

 

anyhow chears.

Baskar
Resident Rockstar
Resident Rockstar

Hi 

we can do in two ways

1. from Query Editor window.

    Right Click on header and choose rename then u can change.

 

2. In Development canvas we can change,

    Here to same "Right Click" Then u can find the rename button from here too.

 

 

let me know if not , i will help u

@Baskar you are talking about changing column names in a table (dataset). I am talking about changing a column header in a TABLE visual...

Hi,

 

If you change to Format pane in the Visualizations Pane you will find a tab called title. Enable it to type and format your title for your visual.

 

Skærmbillede 2016-06-14 kl. 07.23.17.png

/sdjensen

View solution in original post

@sdjensen Thanks. In that way, I have to turn off the headers (by playing with the color). Not ideal but I can accept as a workaround. 

A great hint if you want to have the same title with the same formating in all your visuals is to use the Format Painter (on the Home tab) to copy the settings from one visual to the next.

/sdjensen

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors