Power BI Weekly

Issue #76 - 15th September 2020

No announcements to share with you over the last week, so I'll just share with you this week's highlighted blogs. On the Power BI community blog, Paul Brown discusses Creating a custom or hybrid matrix to achieve grids of data best suited to your needs through manually entered tables and use of the TREATAS function. Elsewhere, Patrick Leblanc has followed up on the How to build a date picker video posted a few months ago with details on how to solve one of the pain points and take it to the next level, with a nice use of Calculation Groups. Finally, Sophie Marchand has written a blog (in French) about The dangers of customizing visuals, referring to the new "Personalize Visuals" capability added to Power BI earlier this year. A couple of good points to keep in mind when enabling this feature, with the aim of avoiding any unintentional ambiguity.

🛠️ Data Prep

Chris Webb (@cwebb_bi) describes Viewing Data Privacy Partition Information With Power Query Query Diagnostics
On the MSSQLTips site, Kenneth A. Omorodion explains how to Improve Power BI Performance with Horizontal Filtering
Soheil Bakhshi (@biinsightnz) blogs about Finding Minimum Date and Maximum Date Across All Tables in Power Query in Power BI and Excel
On the Enterprise DNA blog, Melissa de Korte describes Using The M Function To Create An Extended Power BI Date Table
On the Forsight BI blog, Zainab Balogun explains How To Create Calendar Tables With Power Query
Ruth Pozuelo Martinez (@CurbalEN) talks about the ISNUMBER, ISTEXT, ISDATE equivalent in Power Query or M
On the Towards Data Science blog, Peter Hui explains how to do Joins with Power BI
Adam Saxton (@GuyInACube) shares Connecting to Access fails in Power BI Desktop
On Le CFO Masqué, Kim Leblanc writes Tout ce que vous devez savoir sur les valeurs « null » dans Power Query [French]
Ken Puls (@kpuls) shares an Update to Monkey Tools QuerySleuth
Parker Stevens (@PowerBIElite) describe how to Calculate Business Days for Every Country!

🧩 Data Modeling

Sam McKay (@_EnterpriseDNA) shares a few videos: Dynamically Showcase When Customers Purchase Across All Dates - Power BI Viz Tip, Enterprise DNA Business Analytics Week - Optimizing Key Performance Indicators, How To Create Text Summaries With Dynamic Measures Embedded Into The Description, Advertising & Marketing Campaign Insights Using Power BI - Reporting Application Example, on the Enterprise DNA blog, and posts a few blogs: Power BI Calculated Column vs Measure: A Comparison, Understanding What Data Modeling Is And Creating The Right Relationships and Connecting Data Tables – Tips on Power BI Relationships
On the Business Intelligist blog, Business Intelligist (@bizintelligist) discusses the Custom KPI Trend Calculation – UP ↑ – DOWN ↓ – or About The Same → (PowerBI DAX Tutorial)
On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) shares Practical Introduction to DAX in Power BI – Overview
On the Visual BI blog, Chellammai Muthuraman writes about Leveraging calculation groups in Power BI
Ruth Pozuelo Martinez (@CurbalEN) shares #6 DAX Fridays! 101: Scalar vs table vs other functions - Explaining common DAX errors.
On the Power BI Community blog, Amit Chandak (@amitchandak78) writes Customer Retention Part 1: Month on Month Retention
Marcus Wegener (@PowerBIler) shares Hey Peter! Power BI Modellierung: Eine Kennzahl aus zwei Tabellen [German]

📊 Report Authoring and Interactivity

Chris Hamill (@ChrisHamill17) covers Handling slicer hierarchies with creative conditionally formatted buttons
On the Power BI community blog, Paul Brown discusses Creating a custom or hybrid matrix in PowerBI
Patrick Leblanc (@GuyInACube) writes about the NEXT LEVEL Power BI Date Picker!
On the Towards Data Science blog, Nikola Ilic (@DataMozart) explains how to Build PRO Slicer pane in Power BI and describes a Safe click trick in Power BI
Ruth Pozuelo Martinez (@CurbalEN) describes 2 ways to create a radial bar chart in Power BI
Reid Havens (@HavensBI) discusses Embedding Hover Effect Tooltips to a Card Visual in Power BI
Sam McKay (@_EnterpriseDNA) describes how to Effectively Show Change In One State To Another State Using Unique Visualization Technique and discusses Creating A Dynamic Tooltip With Embedded Charts Using Power BI - Epic Data Viz Tip
Belinda Allen (@MsBelindaAllen) blogs about Using Microsoft Power BI Q&A to ask about a specific field in a column
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes about Les dangers de la personnalisation des visuels [French]
Also on the Power BI community blog, Vivek Ranjan (@imvivran) highlights 3 Useful Features you should know - Power BI Desktop

🚀 Deployment, Security and Operations

On the Power BI community blog, lbendlin describes Working with Power BI Gateway logs
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) explains how to Update “Enter Data” Table in Service without full Publish

🌐 General

Adam Saxton (@GuyInACube) shares Power BI Implementation, migration, colors and more… (Roundup | Sept 7, 2020)
Neil Hambly (@Neil_Hambly) highlights the FREE Power BI Training 'Dashboard-in-a-Day' 21-Sept Details
Matthew Roche (@SQLAllFather) writes about Standardizing on Power BI and shares a video on Data Culture: The Art of the Possible
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 159 - Power BI News & Microsoft Ignite
Matt Allington (@ExceleratorBI) writes about the Power BI Podcast – Wait, What?!
Reid Havens (@HavensBI) describes Guiding user experiences with advanced reporting features
Ted Pattison (@TedPattison) talks about Developing for Power BI with .NET Core Community Webinars
On the Power BI blog, Ramana Sridhar Vaidyanathan describes How Microsoft is showing geographical availability of its services
Brett Powell (@BrettPowell76) describes Processes of Power BI