Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi experts,
i want to add a slicer in powerbi report providing users an option to switch between english to arabic. Is there a way or functionality to get this done considering my actual report is in english (only visual titles, legends and axis titles are required to be change in arabic)
thanks in advance
Solved! Go to Solution.
Hi @vat2do,
Yes, you can build an English ↔ Arabic toggle in Power BI, but there is NO native built-in language switcher (even up to April 2026). You must implement it using DAX + slicer + dynamic titles.
Create a language table as
Language =
DATATABLE(
"Lang", STRING,
{
{"English"},
{"Arabic"}
}
)
Now create a translation table like below and then you can create measures on top of it
Add dynamic measure like
Bind this meaure with visual (Format → Title → fx → Field value) then select the measure Title_Sales
Now update your measures accorsingly to switch the language
Month_Label =
VAR Lang = SELECTEDVALUE(Language[Lang], "English")
RETURN
SWITCH(
Lang,
"Arabic", 'Date'[Month_Arabic],
'Date'[Month_English]
)
Also there is an update in Apr 2026 for Power BI, you can use CULTURE() function to change the language based on their locale, You can check fir this update and here you can read about culture() function.
🌟 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 @vat2do
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.
Step 1) Enable the preview feature
Power BI Desktop → File → Options and settings → Options → Preview features → enable User-context-aware calculated columns.
Step 2) Create a translations table
Build a table with columns for each language: Title, Title_EN, Title_AR. Populate it with all your visual titles, axis labels, and legend labels in both languages.
Step 3) Create a user-context-aware calculated column
Display Title =
VAR _Culture = USERCULTURE ()
RETURN
SWITCH (
_Culture,
"ar-SA", Translations[Title_AR],
"ar-AE", Translations[Title_AR],
Translations[Title_EN]
)
Hi @vat2do,
Yes, you can build an English ↔ Arabic toggle in Power BI, but there is NO native built-in language switcher (even up to April 2026). You must implement it using DAX + slicer + dynamic titles.
Create a language table as
Language =
DATATABLE(
"Lang", STRING,
{
{"English"},
{"Arabic"}
}
)
Now create a translation table like below and then you can create measures on top of it
Add dynamic measure like
Bind this meaure with visual (Format → Title → fx → Field value) then select the measure Title_Sales
Now update your measures accorsingly to switch the language
Month_Label =
VAR Lang = SELECTEDVALUE(Language[Lang], "English")
RETURN
SWITCH(
Lang,
"Arabic", 'Date'[Month_Arabic],
'Date'[Month_English]
)
Also there is an update in Apr 2026 for Power BI, you can use CULTURE() function to change the language based on their locale, You can check fir this update and here you can read about culture() function.
🌟 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!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 41 | |
| 30 | |
| 24 |