Forum Discussion
Solution to switch between Englisch/German Field Names
Hi PBI Community ,
did someone know a Solution to switch between Englisch and German Field Names ?
e.g. in the Online Version some Enduser want to see and Export the Tables with Englisch Field Names and some Enduser want to have it with German Field Names.
Google says there is a solution with Meta Table Translation - be we dont understand how .
No Solution is to dublicate the Tables and work with a Bookmark ( because when we make changes, all the changes must also be done in the other Tabs)
Thanks for helping,
Tine82
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.
6 Replies
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 Tine82,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to MFelix, grazitti_sapna, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member MFelix, grazitti_sapna, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
