Forum Discussion
Solution to switch between Englisch/German Field Names
Hi Tine82,
you can download "Translations Builder" application and then add language as "German (de-DE)". and then translate fields to german in Power BI metadeta.
I've an alternate way to do it, just give user a button to translate the headers using a drop down button using the field parameter option.
You can create the filed parameters using youe columns and measure and give both of them as german or english names and then you can use them using a slicer. Please see a sample .pbix file if it helps. This sample file is just to give you an idea and you can use this functionality as per your needs.
It'll give user the flexibility to chose the language freely.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Hi Tine82 ,
Has grazitti_sapna refered this can be achieved by using the translations on the semantic model.
For each table, column, measure there is a specific meta data property that allows you to add different translations:
Using the Translation builder will deploy that specific field option to your semantic model check the link below
https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder
This is an external tool but currently this can also be done using the TMDL viewer:
This option is directly on the tables itself so no need to duplicate any data.
Hi Tine82,
you can download "Translations Builder" application and then add language as "German (de-DE)". and then translate fields to german in Power BI metadeta.
I've an alternate way to do it, just give user a button to translate the headers using a drop down button using the field parameter option.
You can create the filed parameters using youe columns and measure and give both of them as german or english names and then you can use them using a slicer. Please see a sample .pbix file if it helps. This sample file is just to give you an idea and you can use this functionality as per your needs.
It'll give user the flexibility to chose the language freely.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
grazitti_sapna ,
Thanks for the solution
but we have a lot of Fields and Visualization Tables , is there a option to get the translations directly in the tables (see Red marked)
Hi Tine82 ,
Has grazitti_sapna refered this can be achieved by using the translations on the semantic model.
For each table, column, measure there is a specific meta data property that allows you to add different translations:
Using the Translation builder will deploy that specific field option to your semantic model check the link below
https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder
This is an external tool but currently this can also be done using the TMDL viewer:
This option is directly on the tables itself so no need to duplicate any data.
Hi grazitti_sapna ,
Altough in the past these fields were only available in Tabular Editor or using another external tool currently you can update all the translations using the TMDL editor inside Power BI Desktop that is on my last image this is a script based format that allows for users to easily and without external tools to update all the metadata from any field in a semantic model even the ones that are not available in the UI.
Check the link below: