Forum Discussion
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.
16 Replies
Under Visualisations, click the Fields button ( 2 dotted line rectangles), then click the down arrow on the field you want change and rename. This only changes the column header.
Thanks for the answer
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.
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.
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 :(
ElliotP wrote: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.
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.
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,
