Power BI Weekly
Issue #271 - 13th August 2024
It's been a very quiet week this week, so we'll move straight onto the highlighted content. Firstly, my colleague Barry has walked through our latest video in our "Data Storytelling with Power BI" series: Global Brand Insights - 20 Years of Financial Trends, to add to our existing reports relating to Titanic Survivors and The World Bank World Health and Wealth Report. We try to show different things our different open reports - this time we wanted to show the power of brand logos in a Power BI report to drive an engaging user experience, while analyzing years of financial data with a variety of visuals. Also, the cover page is brilliant (though I can't take credit for that) - simple but very effective. Do take a look!
Elsewhere this week, Reid Havens has hosted Sandeep Pawar to discuss Power BI Automation With Semantic Link. Sandeep's got a wealth of knowledge in all things Semantic Link so I thoroughly recommend you watch this! Finally, Erik Svensen has shared an example pbix file of Using the matrix visual to create a month calendar - a great way of having an interactive calendar without having to use custom visuals.
🛠️ Data Prep
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) describes Getting Started with Power Query in Power BI Desktop
- Rick de Groot (@Rickmaurinus) talks about Removing Milliseconds from a time value in Power Query M | 3 Methods
- Lars Schreiber (@SchreiberLars) covers Quartalswerte Ganzzahlig Monate verteilen mit Power Query [German]
- On the Learning Science YouTube channel, Learning Science describes How to remove a portion of characters form text column or Excel MID like function in Power Query
🧩 Data Modeling
- Chandeep Chhabra (@chandeep2786) describes 5 Super Helpful DAX Tricks
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Show TopN Products and Others in Microsoft Power BI
- On the Business Intelligist blog, Andre Fomin (@AndreFomin) talks about Your Best Option for Master Data Management in Power BI and Microsoft Fabric, Editable by Inforiver
📊 Report Authoring and Interactivity
- On the endjin blog, Barry Smart (@barry_j_a_smart) talks about Compelling Data Storytelling with Power BI: Global Brand Insights - 20 Years of Financial Trends
- Erik Svensen (@donsvensen) writes about Power BI – Using the matrix visual to create a month calendar
- Roland Szirmai (@BILAnalytics) talks about Top N vs Others Visualizations using Power BI - Split of TopN Sales vs Others
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes 4 Power BI Design Tricks
- Ben Richardson (@AcuityTraining) has updated the article: Creating A Combo Chart (Two-Axis Chart) In Power BI
🚀 Deployment, Security and Operations
- Reid Havens (@HavensBI) talks about Power BI Automation With Semantic Link (Sandeep Pawar)
- Chris Webb (@cwebb_bi) writes about Monitoring The Opening Of DirectQuery Connections In Power BI
- On the Power BI community blog, Sam Kumar (@inogic) writes about Automating Tasks in Power BI Reports with Power Automate Buttons