20 Power BI tips in 20 minutes
summary
Twenty quick, actionable tips delivered as a rapid toolkit: use Ctrl+G goto column and the Power Query quick-access toolbar for navigation, prefer Table.SelectColumns vs Table.RemoveColumns to control source dependencies, apply a reusable column-name-transformer function, parameterize KeepRangeOfRows and push different values through deployment pipelines, create date tables and auto time-intelligence with Bravo manage dates, extract measure metadata via EVALUATE INFO.MEASURES or DAX Studio to Excel, auto-generate and hide sum measures with Tabular Editor scripting, use UNICHAR for icon conditional formatting, pixel‑nudge column widths with Shift+arrows, and preview workspace reports with the PowerBI Report Previewer extension.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 1:09Power Query navigation tricks
- 3:57Filtering data in Power Query
- 6:45Power Query shortcuts
- 8:14Creating date tables with Bravo
- 9:36Automating data dictionaries
- 10:39Tabular Editor for measures
- 12:25Table formatting tricks
- 13:51Unicode symbols in DAX
- 14:32Visual selection shortcuts
- 15:15Navigating Data view
- 15:56Bulk text replacement
- 16:39Bullet charts without custom visuals
- 17:21Enhancing cards with titles
- 18:23Previewing reports extension
- 19:29Q&A
related talks
01h 04m60 Reporting Tips in 60 Minutes
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
18mEmpowering Business Through Data
54mData Visualization with Power View and the Tabular Model
51mPower BI Composite and Hybrid Models
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
50mDataOps 101 – A Better Way to Develop and Deliver Data Analytics
33mMaximizing Data Usability for Impact