How I built a flexible time-comparison demo… and why I still reach for UDFs in real-world reports PBIX available at the end of this article! 🥳 As I mentioned in my previous article, one of my Power BI resolutions this year was to try to leverage calculation groups more in my reports. One very obvious use case for me was time-based comparisons : YoY, QoQ, MoM, WoW… the usual suspects. In most of my reports, I end up needing these comparisons across multiple KPIs : turnover, engagement,...

Power BI has come a long way since I started using it more actively in 2021. It’s the best 🤩, and honestly, the pace at which Miguel and the product team are shipping new features is kind of insane (in the best way possible). Based on my experience, client work, and everything that’s been evolving recently in Power BI, here are the 10 resolutions I want to put more intentionally into practice this year . It’s a bit aligned with the year of the horse mindset for me: keeping things simple,...

The solution: a robust approach using Power Query + SVGs PBIX available for download at the end of this article!🥳 Introduction So I’ve been running into this problem (or challenge) for a while: cropping images — profile pictures, avatars, property images, and more — into circular shapes for table visuals. The image data I usually have access to comes in rectangular or square formats, but for many of my designs, it just feels like these images would look much better if they were circular....