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:
-
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 -
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