Change the language of the external text

Question & Answer
, , , ,
3

Hello @akhila

Amazon QuickSight does not provide built-in multilingual support for dynamically changing the language of external texts like textbox, chart titles, subtitles, legends, etc., directly within the visual. However, there are a few ways you can manage and display different languages in your visuals:

Manual Language Switching

You can manually create different versions of your dashboards for different languages. Each version would have the text elements translated into the desired language. This method involves duplicating the dashboard and manually translating the text elements.

Parameter-Based Language Switching

If you want to offer a more dynamic approach, you can use parameters and calculated fields to manage text in multiple languages. Here’s how you can achieve this:

  1. Create a Language Parameter:
  • Go to Parameters in the analysis pane and create a new parameter, e.g., LanguageSelector, with a data type of string. Add the possible values (e.g., “English”, “French”, “Spanish”).
  1. Create Calculated Fields for Each Text Element:

  • For each text element (e.g., chart titles, subtitles), create a calculated field that switches the text based on the LanguageSelector parameter.

  • Example for a chart title:

    ifelse(
    ${LanguageSelector} = ‘English’, ‘Sales by Product’,
    ${LanguageSelector} = ‘French’, ‘Ventes par produit’,
    ${LanguageSelector} = ‘Spanish’, ‘Ventas por producto’,
    ‘Sales by Product’
    )

  1. Use Calculated Fields in Your Visuals:

  • Replace the static text in your visuals with the calculated fields. For example, use the calculated field for the chart title instead of a static string.

    Example Steps

    1. Create a Parameter:
    • Name: LanguageSelector
    • Data type: String
    • Values: “English”, “French”, “Spanish” (or any languages you need)
    1. Create a Calculated Field:
    • Name: ChartTitle
    • Formula:
      ifelse(
      ${LanguageSelector} = ‘English’, ‘Sales by Product’,
      ${LanguageSelector} = ‘French’, ‘Ventes par produit’,
      ${LanguageSelector} = ‘Spanish’, ‘Ventas por producto’,
      ‘Sales by Product’
      )
    1. Use the Calculated Field in a Visual:
    • Go to your visual’s settings for the title.
    • Instead of typing the title, use the calculated field ChartTitle.

By using parameters and calculated fields, you can provide a more dynamic and user-friendly way to switch languages in your Amazon QuickSight dashboards. However, this approach requires careful management of all text elements you wish to translate and may become complex with a large number of text elements and languages.

2 Likes