Using localized labels in a board: translating a dashboard for local entities

  • 6 February 2023
  • 0 replies

Userlevel 6
Badge +7

Dashboards in Pigment provide your users with views into your data so they need to be precise and easy to understand for the best data insights. Users coming from different countries, entities, businesses or regions, prefer to see the Dashboards in their most familiar language.

Most of our modelers tend to create bespoke dashboards, e.g. one dashboard per language, with a different set of filters, text-instructions, colors and available items in the page selectors.

To centralize localization and propagate your changes to everywhere in Pigment where a display name is seen, use custom labels in grids, tables and KPIs for each language that you plan to add.


Adding translations to items in the dimension


First, let’s add a translation for each item in our dimension. After opening the dimension, add a new text-based property.

In my example, I’ve used Name FR in my Country dimension to translate my English names to French names. Japan becomes Japon, United Kindom becomes Royaume-Uni.

Populate this list with either a manual input or an import - or a formula if you can come up with one.


You may be familiar with the Special Properties that can be found in the settings. Although very useful to change the default display name everywhere the dimension is used if you’re only serving a single locale, I won’t be updating it since I want to keep the default language as English and add additional locales for translating the display names centrally.

Nothing to change here


Changing the label in views


A typical grid in Pigment: headers in columns and rows are in English

In this metrics’ view, all the names are displayed in English. To use the French name property I created previously, I can go in the Pivot panel, click on the three dots next to the country, then Update Header Label and choose Name FR. This will show my countries with the French labels instead.

In Pivot, select Country from the Rows then Update Header Label to Name FR

I can then rename the metric in this specific view by choosing Rename next to the metric in the Pivot Panel.

Headers are now in French. Note that the view is saved as a new one.

Once that is done, I can save the view as Default FR and use it whenever I need to display this grid in a French dashboard.



Do you have other tips to make your boards easier to understand for your end-users? Let me know in the comments.


Other features are coming to make boards even closer to your local languages, so I’ll update this article when a new feature comes out.

0 replies

Be the first to reply!