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

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.