Dynamically Add titles to columns

[mkaffo]

Hi,

I am looking to dynamically add titles to column headers, specified by user. 

I have a data sheet (excel) where there are several columns titled, class level 1-10. This is imported into Power BI and I have several graphs/reports based from this. This data sheet will be updated for different users and the class levels will need to be specified.

I want to be able to update these following creating tables/reports as if I rename before creating reports it will be unable to find referenced 'class level'. Any help would be much appreciated. I understand similar queries have been asked but I have not been able to find a response. 

Thanks, 

[Anonymous · Accepted solution]

HI @mkaffo,

AFAK, power query not support auto update column names.
Original table structure will cached in power query steps, if you modify original source, power bi will return error for it can't find the specific columns.

In my opinion, I'd like to suggest you create specific table to store column names, them you can follow below MarcelBeug's solution to dynamic generate column name.

Dynamic column name from its value

Regards,

Xiaoxin Sheng

[mkaffo]

Hi,

I am looking to dynamically add titles to column headers, specified by user. 

I have a data sheet (excel) where there are several columns titled, 'class level 1, 2, ..., 10'. This is imported into Power BI and I have several graphs/reports based from this. This data sheet will be updated by different users and the class levels will need to be specified.

I want to be able to update these following creating tables/reports as if I rename before creating reports it will be unable to find referenced 'class level'. Any help would be much appreciated. I understand similar queries have been asked but I have not been able to find a response. 

Thanks,