Power BI Weekly
Issue #289 - 17th December 2024
In the last week or so we've been given a brief Power BI 2024 Holiday recap, which is less of a recap and more of an advert for next year's FabCon in Vegas. They have, however, announced that December's updates will be in January's update - so we'll have to wait for that one. A couple of small updates we have got are about the Important Update coming to R and Python visuals in Power BI (where runtimes are being updated to Python 3.11 and R 4.3.3) and that Paginated reports now support Power BI languages in the Power BI service. Aside from these updates, Reid Havens has shown a clever way to achieve Easy Vertical Waterfall Charts with Visual Calcs, and Marc Lelijveld has written a rather tempting blog titled Your data security is a joke.
Finally this year, I'd like to point you towards a different type of content to round things off. My colleagues Carmel and Jess recently attended the Women of Silicon Roundabout conference, and Carmel's written about her experience in the blogs Women of Silicon Roundabout: Day 1 and Day 2, sharing some interesting insights about strategies organisations can take to make workplaces more inclusive and support under-represented groups, as well as sharing plenty of compelling technical content gleaned from the 2-day event.
So that's it for this year. Have a wonderful break (for those of you having one), and see you in 2025!
🛠️ Data Prep
- Chandeep Chhabra (@chandeep2786) describes how to Unpivot Multiple Column Groups | Advanced Power Query - Case Study
- Audrée Pellerin (@lecfomasque) covers Intelligence artificielle dans Power BI : Balisage d’image [French]
- Rick de Groot (@Rickmaurinus) describes How to Convert a Data Type to Text in Power Query M
🧩 Data Modeling
- Shivanshu Bisht writes Dynamic Column Part 2 - Modelling + DAX
- On the Power BI community blog, Nirav Dangar writes about Data lineage in DAX
- Ayushi Jain (@wscubetechindia) talks about Unlocking the Power of DAX in Power BI
- Also on the Power BI community blog, Ilgar Zarbali describes Mastering Dynamic Stock Management with Cumulative Measures in Power BI
- Parul Sagar (@parulsagar) writes about Effective Product Pairing Analysis with CROSSJOIN in DAX
📊 Report Authoring and Interactivity
- Reid Havens (@HavensBI) delves into Power BI Upgrade: Easy Vertical Waterfall Charts with Visual Calcs and hosts Waiving the Magic Wand of Data Storytelling (Kristoffer West)
- Bas Dohmen (@HowToPowerBI) talks about UX that makes a difference in Power BI | Highlighting Periods
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) explains How to sort a Power BI visual by a column or measure not shown in the visual?
- On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) discusses Field Parameters in Power BI
- On the Business Intelligist blog, Nikil Prabhakar explains how to Revolutionize Date Filters in Power BI with Super Filter
- On the Power BI community blog, Saud Ansari explains how to Explore Small Multiples for the New Card Visual in Power BI
- Parul Sagar (@parulsagar) writes about Leveraging AI in Power BI: From Insights to Actionable Decisions
- Juliana Smith talks about Implementing Alternative Accessible Colours in Power BI Reports
- Valerie Junk (@porcubi) shows how to Highlight Values Above and Below Target in Power BI Using DAX and a Stacked Column Chart - Tutorial
🚀 Deployment, Security and Operations
- On the Power BI blog, Nirupama Srinivasan (@MSPowerBI) shares an Important Update coming to R and Python visuals in Power BI
- Also on the Power BI blog, Nirupama Srinivasan (@MSPowerBI) announces that Paginated reports supports Power BI language in the Power BI service
- Jon Stjernegaard Vöge describes Fabric Quick Tips: Hiding Power BI Report Page Navigation in Workspace Apps and Organizational Apps
- Chris Webb (@cwebb_bi) blogs about Sending Alerts From Fabric Workspace Monitoring Using KQL Querysets And Activator
- Marc Lelijveld (@MarcLelijveld) writes Your data security is a joke!
- On the Prologika blog, Teo Lachev (@tlachev) covers Prologika Newsletter Winter 2024
🌐 General
- Soheil Bakhshi (@biinsightnz) discusses Power BI Desktop Versions Demystified: Part 2, Store vs. Download Version – Key Differences and Use Cases
- On the Power BI blog, Patrick Leblanc (@GuyInACube) blogs about Power BI 2024 Holiday recap