Forum Discussion

mkaffo's avatar
mkaffo
New Member
8 years ago
Solved

Dynamically Add titles to columns

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's avatar
    Anonymous
    8 years ago

    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

     

2 Replies

  • mkaffo's avatar
    mkaffo
    New Member
    8 years ago

    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, 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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