How to translate visual titles,filter names from en to selected language?

Hi Team,
We have a requirement to show the dashboard visual titles, filter names, insights content to the user in selected language irrespective of widget content, is there any way to do so?

Hi,

there is a blogpost from Francesco Marelli about multilingual dashboards.

I had read this one, in this we are translating data not the visual titles and filter names, we only the translated titles,filter names,insight content if it has static text in en,the data from data set will be in en.

My requirement is similar to this post
I have a requirement to translate our Quicksight dashboard.

We are currently configured a “language” parameter which contains the language user desired to see the dashboard in. We are using this parameter to filter the data in our data set which has rows for each available language. This works well for the data display in our visuals on the dashboard.

The problem I have is regarding the titles and labels on the visuals. I’d like these to be updated depending on the language parameter as well. I’ve found you can template the title, i.e., <<$language>> to include the parameter, but I can’t find anyway to “lookup” the desired value using the parameter as a key.

I’ve looked at calculated fields which can be determined using parameters, but unfortunately you can’t template titles/labels with them.

The only option I’ve considered at this point is having to duplicate the dashboard in every single language supported and then routing the users to the correct dashboard.

Does anyone else have any other ideas?

Hi @gillepa,
can you please help on this question?

Hi @Schruti -

I would try a couple of things. Not sure which one is better for your use case as it depends on how easy/hard it is for you to modify the data set and redesign the visuals:

  1. restructure your data set to show different COLUMNS per language, instead of different rows. The column names should be the ones you want to display in the visuals. Then create a Parameter that uses Dynamic Default Values. More info here:
    Creating parameter defaults in Amazon QuickSight - Amazon QuickSight
    It might work with a little bit of creativity

  2. Rearrange your dataset to show different languages as Columns (not Rows).
    a. Each Column should have the desired name (for French, the column name should be in French). For example, if you have Sales Revenue as a column, create another column for French "Chiffre d’Affaires’…
    a. Create a Parameter SelectLanguage as string with Default value of “Sales Revenue”. This is the name of the column with English title for English readers
    b. Create a calculated field that references the parameter.
    Calculated Field:
    ifelse(
    Parameter = ‘English’, “Sales Revenue”,
    Parameter = ‘French’, ‘Chiffre d’Affaires’,
    Parameter = ‘Hindu’, etc.
    NULL)
    c. Add the parameter to visual and edit it to add a dropdown where you add additional values: English, French, Hindu etc.
    d. add the calculated field to the visual as a column
    e. edit the visual and go to Group-by Column Names
    f. where you see the Calculated Field’s name click on the 3 hotizontal lines and make sure you select the parameter as the value for that field

Let us know if any of this suggestions work for you,
GL