Let End Users Drive: Empowering User Control in Power BI Reports

on YouTube ↗50m

" summary

Built a live “bom pile” Power BI report that tracks serial-level failures with non‑additive measures (last‑date quantity per period) and a daily snapshot history; users change aging bins by editing an external Excel/SharePoint table and refreshing, set a numeric target slider that triggers DAX hex conditional formatting to highlight bars, and switch measures/dimensions with field parameters (fallback via disconnected tables for Report Server). Uses Power Query, Zebra BI visual, drillthrough details, optional Power Automate refresh, and a GitHub sample — the demo works end‑to‑end.

AI-written summary · about

" chapters (16)

1. 0:00Introduction
2. 1:15Session objectives
3. 2:41Flexibility in Power BI reports
4. 5:15End-user flexibility tools
5. 8:29Demo: manufacturing context
6. 10:59First user request
7. 13:28Historical data and measures
8. 16:41Custom visuals and drill-through
9. 17:44Dynamic aging bins
10. 23:00Conditional formatting with targets
11. 28:20Dynamic measure switching
12. 31:56Field parameters limits
13. 36:18Dynamic dimension switching
14. 40:15Improving report adoption
15. 44:12Summary and best practices
16. 47:23Resources and closing

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 25mTake your Power BI Reports to the Next LevelIndira Bandari · Power BI Women Summit 2021
• 01h 04mCreate Reports That Help You Run Your BusinessAvi Singh · PASS Business Analytics Conference 2015
• 58mReal world PowerBIMatt Davies · NDC Sydney 2017
• 50mBuilding an Empire - Implementing Power BI Step by StepAlexander Arvidsson · Power Platform Virtual Conference 2021
• 48mCombine Power BI with External ToolsMiguel Félix · SQLBits 2023
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 01h 01mVisualization Choices: What, When, and How?Paul Turley · PASS Business Analytics Conference 2013