cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Rename column headers in a table

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.

 

I Create measure profit, But I need name of the column that table will decide.

for example . I will calculate two tables  with columns 1) Employee Profit 2) Office Profit

 I need to rename the second column -Profit by employees , Profit by offices  etc.

11 REPLIES 11
Highlighted
Continued Contributor
Continued Contributor

Re: Rename column headers in a table

If you don't want to rename your measures, or create new ones with the proper names, as in 

 

[Employee Profit] = [Profit]

 

you could create an image with the titles you want and place it above the table.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
Highlighted
Post Prodigy
Post Prodigy

Re: Rename column headers in a table

@pstanek

 

Easy solution. Click on your visual, go to Format (little painbrush below the Visualisations on offer), Title, Title Text. You can change it to anything you want and it won't impact your back end setup!

Highlighted
Microsoft
Microsoft

Re: Rename column headers in a table

@pstanek

 

In Power BI Desktop, the header only takes the data field. We can't modify the Column Header in visual format. It only supports changing Font color, Background color and Outline.

89.PNG

 

For your requirement, the best workaround is adding "dummy" measures/columns with expected names as @asocorro suggestd.

 

You can also submit a feature request on Ideas: https://support.powerbi.com/forums/265200-power-bi

 

Regards,

Highlighted
Helper IV
Helper IV

Re: Rename column headers in a table

Hi,

I dont see any column header property for table in the properties pane.

I tried selecting whole table.

is it the property of the table only...?

is it not there in the version um using, 2.31.4280.361 64-bit (January, 2016)...?

 

Thanks in advance.

Highlighted
Helper I
Helper I

Re: Rename column headers in a table

I do not want to rename columns or measures.

However can I make part of the header change dynamically... with a parameter ..etc?

For example I want to include Year info in the column header(this will change every week)

 

Profit 2016 (for Current Year)

Profit 2015 (for Last year)

 

Profit Week 10 Year 2016

Profit Week 10 Year 2015

 

It wouldn't be possible to create an image etc.. as even this would change.

Highlighted
Post Partisan
Post Partisan

Re: Rename column headers in a table


@ElliotP wrote:

@pstanek

 

Easy solution. Click on your visual, go to Format (little painbrush below the Visualisations on offer), Title, Title Text. You can change it to anything you want and it won't impact your back end setup!


In this case you only add Title, you do not change Column title. But it is a good idea. You only need to hide Column titles and shift visual Title so that it matches your columns. I then make Column headers white font as there is no option not to display them at all.

Highlighted
Frequent Visitor

Re: Rename column headers in a table

how did you go with this? Did you get it to work?

 

I managed to get dynamic columns names using this https://stackoverflow.com/questions/34858733/dynamically-rename-a-set-of-columns-using-power-query

 

But unfortunately when you add it to the report, once the column name changes the report breaks because it's expecting the previous column name 😞

 

Highlighted
Advocate I
Advocate I

Re: Rename column headers in a table

FYI for those still looking for a solution to this - you can rename the headers by double clicking on the name of the measure under 'Values', which will allow you to edit the name

Highlighted
Community Champion
Community Champion

Re: Rename column headers in a table

Yes, this was a feature inclusion that came after this particular thread.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors