Dynamic Language and Direction Change in Power BI Reports (English and Arabic)

[ashi7upt]

I am working on a Power BI report that needs to support two languages:

1. English
2. Arabic

The challenge is that the data representation and layout need to change dynamically based on the selected language. This is because:

• English is written from left to right (LTR).
• Arabic is written from right to left (RTL).

I am looking for a way to change both the language and the orientation at the same time, based on the user's language selection. Here’s what I need:

Objective:

• When the user selects English, the report should use LTR formatting and display text/content in English.
• When the user selects Arabic, the report should switch to RTL formatting and display content in Arabic.

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

Hi , 

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

thanks,

Prashanth Are

[ashi7upt]

I have not received solution.

[v-prasare]

@ashi7upt, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by @FarhanJeelani helps you? or let us know if you need any further assistance here? 

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

Did w answer your question? Mark post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 

[v-prasare]

@ashi7upt, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by @FarhanJeelani helps you? or let us know if you need any further assistance here? 

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

Did w answer your question? Mark post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 

[FarhanJeelani]

Hi @ashi7upt ,

Dynamic language and direction changes in Power BI require a combination of measures, translations, and layout adjustments. Here’s how you can achieve this for English (LTR) and Arabic (RTL):

Steps to Implement:

1. Language Selection Mechanism

• Create a parameter table to allow users to select the language. Example:

  Language Table:
  LanguageID | LanguageName
  1          | English
  2          | Arabic

• Create a slicer in your report using the LanguageName column.

2. Dynamic Translations

• Add a translation table containing labels or text in both languages. Example:

  Translation Table:
  LabelKey    | EnglishText       | ArabicText
  Title       | "Sales Report"    | "Arabic Translation Here"
  Total       | "Total Sales"     | "Arabic Translation Here"

• Write a DAX measure to dynamically switch text based on the selected language:

  DynamicText = 
  VAR SelectedLanguage = SELECTEDVALUE('Language Table'[LanguageName])
  RETURN
      SWITCH(
          SelectedLanguage,
          "English", MAX('Translation Table'[EnglishText]),
          "Arabic", MAX('Translation Table'[ArabicText]),
          MAX('Translation Table'[EnglishText]) -- Default to English
      )

3. RTL and LTR Layout Adjustments

• Use Bookmarks to create two separate layouts:

  • One layout for English (LTR alignment).
  • One layout for Arabic (RTL alignment).

• In the Arabic layout:

  • Align visuals to the right.
  • Flip the orientation of charts and slicers.
  • Reverse horizontal elements, like bar charts or progress indicators.

• Use a DAX measure to dynamically control which bookmark is shown:

  SelectedLayout = SELECTEDVALUE('Language Table'[LanguageName])

  Use conditional navigation based on this measure.

4. Dynamic Titles and Labels

• Update the titles and labels of visuals using dynamic measures:
  • For example:

    TitleMeasure = 
    SWITCH(
        SELECTEDVALUE('Language Table'[LanguageName]),
        "English", "Sales Overview",
        "Arabic", "Arabic Translation Here"
    )

5. Testing and Deployment

• Test language switching and layout changes thoroughly.
• Ensure visuals like charts, tables, and slicers respond dynamically to both RTL and LTR formats.

Tips:

• Font Compatibility: Use a font that supports both English and Arabic characters.
• Auto-Refresh: To avoid manual refresh issues, ensure slicer selections dynamically update visuals and layouts.
• RTL/Theme Settings: Customize theme JSON files to set RTL for Arabic layouts.

Outcome:

When a user selects a language:

• The report text updates dynamically (e.g., "Sales Report" switches to its Arabic equivalent).
• The layout adjusts between LTR (English) and RTL (Arabic).

Let me know if you need further help or sample implementation!

Please mark this as solution if it helps. Appreciate Kudos.

[ashi7upt]

Thank you for your response, it is helpful but it does not solve my full problem. 
Is there a way to change the embedded report's direction based on the application's language selection from right to left on Arabic language selection from left to right when the English language is selected?

[v-prasare]

Hi @ashi7upt,

Hope you are doing well, Sorry for delayed response here.

PFB similar/duplicate thread answered by user in community forum:

Request for RTL Support When Embedding Reports in ... - Microsoft Fabric Community

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others find answers quickly!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 

[v-prasare]

@ashi7upt , As we haven’t heard back from you, we wanted to kindly follow up to check if the above solution provided by our community member answers your query? let me know if you need any additional help.

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos"