Edit

Share via

Set the locale for a Power BI paginated report or text box (Power BI Report Builder)

  • Article

APPLIES TO: Power BI Report Builder Power BI Desktop

The Language property on a Power BI paginated report or a text box contains the locale setting, which determines the default formats for displaying report data that differ by language and region, for example, date, currency, or number values. The Language property on a text box overrides the Language property on the report. If no value is specified for Language, the Power BI service uses the language setting of the browser for published reports. By default, the Power BI language is the browser language, but you can overwrite that in the Power BI settings and use a fixed language.

For HTML reports, you can override the default Language value and use the language specified by the HTTP header of the browser client by using the built-in field User!Language in an expression for the Language property of a report or a text box.

You can also specify the Language property for a report in a URL. For more information, see Set the language for report parameters in a URL.

Set the locale for a report

  1. In Design view, select outside the report design surface to select the report.

  2. In the Properties pane, for the Language property, type or select the language that you want to use for the report.

Set the locale for a text box

  1. In Design view, select the text box to which you want to apply the locale settings.

  2. In the Properties pane, set the following properties:

    • Calendar property: type or select the calendar that you want to use for dates.

    • Direction property: type or select the direction in which the text is written.

    • Language property: type or select the language that you want to use for the text box. This value overrides the Language property for the Report.

    • NumeralLanguage property: type or select the format to use for numbers in the text box.

    • NumeralVariant property: type or select the variant of the format to use for numbers in the text box.

    • UnicodeBiDi property: select the level of bidirectional embedding to use in the text box.

Set translated labels for a paginated report parameter prompt (Power BI Report Builder)

The User!Language expression can be used to define translated parameter prompts based on the user's browser language. To do so, follow these steps:

  1. In Design view, define the parameter.

  2. Specify the Name for the parameter.

  3. For the Prompt, define an expression. For example:

    =IIF(User!Language.StartsWith("en"), "Color", "Farbe")

    Screenshot of locale for parameter prompt.

    To support more than two languages, use the VB Switch function.

Note

The Power BI language that's used for when the report is executed in the Power BI service. By default the Power BI language is the browser language, but users can overwrite that in the Power BI settings and use a fixed language.

Related content