Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

Anonymous
Not applicable

@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
Anonymous
Not applicable

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.