# 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

```javascript
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.

{% hint style="info" %}

* **Writeback Matrix:** Navigate to Settings > Global Settings> Localization Settings to create translation entries.
* &#x20;**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.
  {% endhint %}

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FQId5e1mSL5y6sfPQW5XD%2Fimage.png?alt=media&#x26;token=86d8d223-1441-429c-ba11-f9a0b9c838ed" alt=""><figcaption><p>Localization Settings</p></figcaption></figure>

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FpUwjCffqg7tr3lNt4OGg%2Fimage.png?alt=media&#x26;token=03f161b9-a673-48ce-8968-b5f937209849" alt=""><figcaption><p>Use GETLOCALELABEL and pass they key in the Title</p></figcaption></figure>

Similarly, when you create custom groups, use the GETLOCALELABEL function. [Learn more about creating column groups](https://docs.inforiver.com/working-with-inforiver/3.-basic-interactions/create-visual-hierarchies#id-1.-group-columns).&#x20;

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FXGdBr9sdo6OSuPzXDNFl%2Fimage.png?alt=media&#x26;token=cee07429-c530-4615-8604-7030fbf35629" alt=""><figcaption><p>Creating custom groups with localization settings</p></figcaption></figure>

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FHUHxlAEm8njReTas2NO1%2Fimage.png?alt=media&#x26;token=8ac177f2-1eed-42ec-ab56-93a41c770796" alt=""><figcaption><p>Language changed to French</p></figcaption></figure>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FesJbNG0kKQIbZ4IMRPtG%2Fimage.png?alt=media&#x26;token=4fb71845-b135-4829-85bc-bd3c0fd12775" alt=""><figcaption><p>Language changed to German</p></figcaption></figure>
