Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
vat2do
Helper III
Helper III

language slicer in powerbi report

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

1 ACCEPTED SOLUTION
grazitti_sapna
Super User
Super User

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 

grazitti_sapna_0-1777880501740.png

 

 

Add dynamic measure like 

 

grazitti_sapna_0-1777880774216.png

 

 

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!

View solution in original post

3 REPLIES 3
v-aatheeque
Community Support
Community Support

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.

 
cengizhanarslan
Super User
Super User

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]
)
 
Step 4) Use these columns as dynamic titles via fx
_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn | Follow on Medium
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.
grazitti_sapna
Super User
Super User

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 

grazitti_sapna_0-1777880501740.png

 

 

Add dynamic measure like 

 

grazitti_sapna_0-1777880774216.png

 

 

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!

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.