Is it possible to rename column names based on a Parameter?

[astarczyk]

Hello, I'm loading data from Excel file to Power BI and I'm trying to rename column names based on Parameter (Language, EN for English and DE for German), like so:

It renames the columns in Power Query correctly, but then in the report it doesnt recognize them as the same columns used in the visuals:

But if I manually rename the columns, without the parameter, it recognize them in the visuals as the same ones:

Is there any way to make this work with the parameter? Or am I missing something obvious?

Thank you in advance 🙂

[v-echaithra]

Hi @astarczyk ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Chaithra E.

[v-echaithra · Accepted solution]

Hi @astarczyk ,

Unfortunately, Power BI does not currently support dynamic column renaming in Power Query if those column names are referenced in visuals. Column names in visuals are bound statically at design time, so when the column name changes due to a parameter, the visuals lose track of them, even if the data is still there.

Best Regards,
Chaithra E.

[astarczyk]

Hi, thank you for your responses, the report I would like to implement it in contains around 50 tables, so I'd like to ask for a solution that would ideally be a step in PowerQuery (that I'd apply for each table), if at all possible, instead of using measures, since creating measures or translation tables for each of those 50 tables would be quite time consuming and complicated to maintain afterwards. 

Thank you!

[rajendraongole1]

Hi @astarczyk  - Rather than renaming columns dynamically, keep the internal column names constant and use a translation table to switch labels dynamically in visuals.

create one language selector table with the languages column that you have eg., EN and DE labels, 

create a measure now with selectedvalue column with 

SelectedLanguage = SELECTEDVALUE(LanguageSelector[Language], "EN")

Now we can create last measure to dynamic 

DynamicLabel =

VAR lang = [SelectedLanguage]

RETURN

    SWITCH(lang,

        "EN", LOOKUPVALUE(Translation[EN Label], Translation[FieldName], "Amount"),

        "DE", LOOKUPVALUE(Translation[DE Label], Translation[FieldName], "Amount"),

        "Amount"

    )

Hope this works. 

[pallavi_r]

Hi @astarczyk ,

Yes, it is possible to change the columns names on visual dynamically using parameters. Please check these links for detailed steps.

https://www.youtube.com/watch?v=Y9ETaaOgNLk

https://www.youtube.com/watch?v=BLNqU2jJ7u0

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi