Power BI: User-Aware Multilingual Column

Key insights

• User-context-aware calculated columns: Power BI now lets calculated columns run at query time using the Expression Context set to user context, so the column value can change depending on who opens the report.
  This makes a single model return different text for different viewers without recreating or duplicating models.
• Key DAX functions: Use user-aware functions such as USERCULTURE() (for language/locale), USERNAME, USERPRINCIPALNAME, CUSTOMDATA, or USEROBJECTID inside the expression to detect the viewer and return translated or personalized values.
  These functions drive dynamic labels like month names or product names in the viewer's language.
• Main benefits: Build true multilingual semantic models with one dataset — "one model, many languages" — and reduce report-side work; also enable user-specific labels and some security-aware display logic directly in the model.
  This simplifies global reporting and improves maintainability.
• How to implement: Set the calculated column's Expression Context = User Context, include USERCULTURE() or other user functions in the formula, and configure Sort by Column and Group By Columns where needed to preserve correct ordering and selections.
  Use stable grouping keys so translated labels do not break visuals or uniqueness.
• Availability: The capability is currently a preview feature in Power BI Desktop and relies on the Expression Context property; reported compatibility includes Import, DirectQuery and some Direct Lake / OneLake scenarios, but service rollout may vary.
  Test in your environment before relying on it for production use.
• Caveats and best practices: These columns are not materialized at refresh — Power BI evaluates them per user at query time — so plan for any performance or caching differences and verify security behavior.
  Always keep a stable grouping key, test visuals for selection consistency, and validate behavior across user locales before deployment.

Keywords

Power BI multilingual, multilingual Power BI DAX, user-context-aware calculated column Power BI, dynamic translations Power BI, locale-aware calculated columns, DAX localization techniques, translation table Power BI, multilingual Power BI reports