Forum Discussion
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.
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 :(
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
