Forum Discussion
Multilingual reports
We have a use case where we need to convert the PowerBi report into multiple languages (Spanish, French, Portugese). What we mean is -
1) The column names, chart names, text should all change to the required language.
2) When a user exports, it should export in that specific language.
How can this be done? Also, does it need specific type of license to achieve it?
Hi abansalgeoforce , Thank you for reaching out to the Microsoft Community Forum.
The translations you applied through Translator Builder or Tabular Editor only cover model metadata (table names, column names, measure names). Power BI does not translate report layer text such as KPI titles, chart titles, axis labels or text boxes. Those elements must be made dynamic by returning translated strings from the model.
The standard pattern is a Translation table (Language, Key, Text), a language selector and a DAX measure that looks up the appropriate text. You then bind that measure to each visual’s title/axis via Format -> fx -> Field value. For visuals or properties that don’t support field value formatting, you overlay a Card/Text box driven by the measure. Exports will reflect whatever language is rendered on screen. No special license is required.
Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn
Create Multiple-Language Reports with Translations Builder - Power BI | Microsoft Learn
Plan Translation for Multiple-Language Reports in Power BI - Power BI | Microsoft Learn
8 Replies
Hii abansalgeoforce
You can make a Power BI report multilingual by storing all translations (column names, titles, labels, etc.) in a separate translation table and switching text dynamically based on a language slicer. Every visual title and column header must use a DAX measure that returns the translated text (Power BI does not automatically translate metadata). Exported files also follow whatever text is shown on screen, so users will get the export in the selected language. No special license is required this works in Pro, Premium Per User, and Premium capacities.
Hi abansalgeoforce,
Look at these threads:
1. https://community.fabric.microsoft.com/t5/Desktop/multilingual-reports-in-power-bi/m-p/48244462. https://community.fabric.microsoft.com/t5/Desktop/Multilingual-reports-in-Power-BI/m-p/4115556
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedInHi abansalgeoforce , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.
Using translator buider, we are able to easily translate the table names, column names and field names.
Howeverm it doesn't update the titles on the KPIs (tiles), or Charts titles, axis etc.
I think we probably need to create DAX functions for each of those. Is that correct understading?Hi abansalgeoforce , Thank you for reaching out to the Microsoft Community Forum.
The translations you applied through Translator Builder or Tabular Editor only cover model metadata (table names, column names, measure names). Power BI does not translate report layer text such as KPI titles, chart titles, axis labels or text boxes. Those elements must be made dynamic by returning translated strings from the model.
The standard pattern is a Translation table (Language, Key, Text), a language selector and a DAX measure that looks up the appropriate text. You then bind that measure to each visual’s title/axis via Format -> fx -> Field value. For visuals or properties that don’t support field value formatting, you overlay a Card/Text box driven by the measure. Exports will reflect whatever language is rendered on screen. No special license is required.
Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn
Create Multiple-Language Reports with Translations Builder - Power BI | Microsoft Learn
Plan Translation for Multiple-Language Reports in Power BI - Power BI | Microsoft Learn
Hi abansalgeoforce,
I use Tabular Editor and strongly recommend it to achieve this goal. Please take a look at the links below for more details.Or check this other topics:If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Hi abansalgeoforce , Thank you for reaching out to the Microsoft Community Forum.
We find the answer shared by rohit1991 is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you rohit1991 for your valuable response.
Hi abansalgeoforce , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.
