USERCULTURE
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the locale (language code-country code) for the current user, determined by the operating system, browser settings, or Power BI service.
Note: This function is currently supported in Power BI Premium per capacity, Power BI Premium per user, and Power BI Embedded only.
USERCULTURE()
This expression has no parameters.
Locale as a string.
In the Power BI service, locale is determined by Settings > Language > Language Settings. The default is determined by the user's browser language setting.
When used in calculated table and calculated column expressions, the result may differ depending on whether the table is in DirectQuery or Import mode. When in DirectQuery mode, the result is determined by the language (locale) specified in Language Settings in the Power BI service. The default in Language Settings specifies locale is determined by the user's browser language setting, which means the same calculated table or column can return different results depending on the browser language settings for each user. When in Import mode, the result is statically determined during refresh and will not vary at query time. For managed refreshes, such as scheduled or interactive, locale is not based on the user’s browser language setting but instead uses an invariant locale. The invariant locale, however, can be overridden by using the XMLA endpoint to specify a custom locale.
When combined with the Field parameters feature in Power BI, USERCULTURE can be used to reliably translate dynamic visualization titles and captions when used in measure and row-level security (RLS) object expressions within the same model. However, expressions containing USERCULTURE called from outside the model, such as queries and live-connect report measures, should not be relied upon for correctly translated titles and captions.
USERCULTURE returns the correct user locale when used in object expressions called from within the model such as measures, row-level security (RLS), and calculation items. However, it may not return the correct user locale when used in expressions from outside the model, such as queries and live-connect report measures.
In Live-connect reports, USERCULTURE may not return the correct user locale when called from a report measure expression.
For the following expression,
FORMAT(TODAY(), "dddd", USERCULTURE())
Depending on the language setting for the current user, USERCULTURE returns the current day, for example:
Locale | Formatted weekday |
---|---|
de-DE | Dienstag |
en-US | Tuesday |
es-ES_tradnl | martes |
eu-ES | asteartea |
it-IT | martedì |
nl-NL | dinsdag |
pl-PL | wtorek |
ro-RO | marți |
ru-RU | вторник |
uk-UA | вівторок |
Expression-based titles in Power BI
USERNAME
USERPRINCIPALNAME
USEROBJECTID