cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors