GETLOCALELABEL

You can configure translations in Inforiver based on the language settings in Power BI. If your report has a global audience, you can configure calculated rows/columns or column groups to display dimension categories based on pre-defined translations when the language is switched.

Syntax

GETLOCALELABEL('Label')

Arguments

Label – The Key configured in Localization settings. Required.

Return value

Value corresponding to the Key as defined in Localization Settings.

Example

In this example, we'll demonstrate how to convert product names and custom groups with the GETLOCALELABEL function.

• Writeback Matrix: Navigate to Settings > Global Settings> Localization Settings to create translation entries.

• Reporting Matrix: Navigate to Display Settings > General > Localization Settings to create translation entries.

• The screenshots shown in this section are from WB Matrix, but the functionality is the same.

Localization Settings

Use the GETLOCALELABEL function in the Title field and pass the Key specified in the translation config.

Use GETLOCALELABEL and pass they key in the Title

Similarly, when you create custom groups, use the GETLOCALELABEL function. Learn more about creating column groups.

Creating custom groups with localization settings

Notice how the row categories and column groups are implicitly changed to French and German.

Language changed to French

Language changed to German