Do You Speak English? Localized Reports with Power BI
summary
Shows a working, data-driven method to switch report UI and dimensional content languages in Power BI using a 3DS filter trick in DAX, a bridge table with duplicated dimension rows to avoid many-to-many errors, and optional cognitive services for automated translation in Power Query. Demonstrates pivoting text-component tables into columns for visuals, explains why bidirectional filters are needed, warns about slicer preselection problems, and reports the approach scales to a 1M-row dimension though model complexity and refresh/API costs are trade-offs.
AI-written summary · about
chapters (6)
- 0:00Start
- 11:22Localization
- 45:46Text Elements
- 47:10Model Metadata
- 48:22Limitations and considerations
- 49:41Questions?
related talks
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
25mTake your Power BI Reports to the Next Level
01h 04mCreate Reports That Help You Run Your Business
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
51mTroubleshooting Power BI Report Performance
50mLet End Users Drive: Empowering User Control in Power BI Reports
58mPower BI for the Developer
18mEmpowering Business Through Data