Issue with Translations Builder post publishing

Hi vrachelann,

You want:

• One single Power BI report (no page duplication),

• Automatic or user-driven switching between Arabic and English,

• Without manually editing the report URL or creating two separate versions.

I found some ressources : 

- https://www.youtube.com/watch?v=zCEtzxhGn-Q

- https://www.youtube.com/watch?v=q2pS9IBzk-Q

- https://powerbi.microsoft.com/en-ie/blog/building-multi-language-reports-for-power-bi-in-2023/

- https://learn.microsoft.com/en-us/dax/userculture-function-dax

How the Dynamic Multilingual Setup Works : 

1. Create a disconnected “Language” table

You create a simple table with your supported languages:

LanguageTable = DATATABLE(
"Language", STRING,
{{"English"}, {"Arabic"}}
)

Add this table as a slicer in your report so the user can pick their language

2. Create a translation table

This is a key concept from the video.

Make a table that maps your text labels to each language.

You can store this as:

• A separate table in your Power BI model (Translations), or

• A small Excel file imported into your dataset.

3. Create a translation measure

Use DAX to dynamically pick the correct label based on the user’s slicer selection:

SelectedLanguage =
SELECTEDVALUE(LanguageTable[Language], "English")

Translate =
VAR _LabelKey = SELECTEDVALUE(Translations[LabelKey])
VAR _Language = [SelectedLanguage]
RETURN
SWITCH(
TRUE(),
_Language = "Arabic", LOOKUPVALUE(Translations[Arabic], Translations[LabelKey], _LabelKey),
LOOKUPVALUE(Translations[English], Translations[LabelKey], _LabelKey)
)

. Use the measure in your visuals

Instead of hardcoding text in your cards, titles, and buttons:

• Use measures or dynamic titles referencing the translation measure.

Example:

• Card title → = [Translate]

• Button label → set to “fx” (format expression) → bind to [Translate]

✅ Now, when the user changes the slicer from “English” to “Arabic,” all text labels in your report dynamically switch.

Hope it can help you !

Best regards,

Antoine