How to Create a Bilingual Dashboard in Tableau

Whether you follow the first approach of creating a translated dimension in the underlying data or duplicating the dimension from within the authoring interface, you will now have a dimension for each language.

Now that we have the dimension in both languages, we have to create a parameter that will eventually allow ourselves and our end users to decide which language the dimensions are displayed in. The parameter should have a data type of String and a list of allowable values for the languages you want to include. If you’re new to parameters, see An Introduction to Parameters in Tableau. Here’s how the logic for my parameter looks at this point.

Parameters do very little on their own. In order for Tableau to display the language based on the parameter selection, we must integrate the parameter into a calculated field that gives Tableau instructions for how to handle each option. To do so, I will create a new calculated field with this code:

CASE [Language Selector]
WHEN “English” THEN [Region]
WHEN “Spanish” THEN [Región (Spanish)]
END

To be clear, you would need to set up a calculated field for each bilingual dimension you wanted to use. However, you would only need to set up the Language Selector parameter one time because it can be used across calculated fields and even across data sources. Changing the parameter value once will change the language being displayed everywhere.

To finalize my sample quantity by region view, I will replace the Region dimension on the Columns Shelf with my newly created Bilingual Region Dim calculated field.

Lastly, in order to have one-click access to choose whether the dimension members are displayed in English or Spanish, I must show the parameter control by right-clicking on the Language Selector parameter and choosing “Show Parameter Control”. Now when the user chooses English, quantity is broken down by the Region dimension and the regions are displayed in English.

When the user chooses Spanish, quantity is broken down by the Región (Spanish) dimension and the regions are displayed in Spanish.

We recreated one chart to illustrate this tactic, but you could roll out a similar approach to translate an entire dashboard. This method can also be used to white label dimension members. For example, say you wanted to show an employee on your team how they are stacking up in context of the rest of the team, but don’t want to display the names of every individual. You could copy the “Employee” dimension and change the aliases to something like Employee 1, Employee 2, and so on. One parameter option would allow you to evaluate the entire team, but then you can toggle to the white labeled version when having your one on one meetings.

Finally, if you are displaying measures that require different formats based on the language being selected, you will also benefit by reading my post, How to Dynamically Format Numbers in Tableau.

Thanks for reading,
– Ryan