A practical slicer pattern that automatically updates to the latest data PBIX available for download at the end of this article! 🥳 So this is more of a micro-tip — I’ve had to use it recently so thought it could be a good idea to share the idea with others in case you run into the same situation. 🤓 In many reports, users need to: View current data by default But still be able to go back in time using a slicer In those cases, the report usually contains both current and his

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, e

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: keepin

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

PBIX available at the end of this article! 🥳 When Microsoft said they were revamping the Image visual, I was really excited, and after experimenting with it, even more by all the design options and capabilities it offers! 🤩 The new Image visual finally gives us the dynamic, flexible, pixel-perfect control we’ve needed for years. Here’s a short demo of a visual card I created with it! And if you also work with icons, SVGs, KPIs, navigation elements, nudges, or any kind of mi

A flexible, scalable way to generate beautiful SVG pills for statuses, priorities, and tags using Power BI’s new User-Defined Functions. PBIX available at the end of this article 🎉! Introduction Power BI’s new User-Defined Functions (UDFs) have opened up a whole new way to streamline and accelerate both team and individual report development. As I start to integrate them into more and more projects, some patterns are clearly emerging: a few UDFs end up being reused everywher

A DAX-based workaround to add color logic where Power BI doesn’t (yet) let us 😅 PBIX available for download at the end of this article 🥳! Introduction I love Power BI’s chart labels, so many improvements have been brought to them over the years and they really do empower us to display insights in a meaningful. However, one of the current limitation is that we can’t conditionally format their background 😝. It’s not a HUGE problem, but depending on your dashboard’s visual st

By Isabelle Bittar for KI Data Science 🪄 A plug-in section you can add to any report to empower your users. PBIX included!  🎉 (Download link at the end of this article) Introduction When people start using your reports — like really  using them — they don’t end up with fewer questions… they end up with more . 😅 That’s actually a good thing. It means your dashboards are doing their job — sparking curiosity and deeper analysis. But it also means users will often ask for “jus

Go beyond FORMAT() hacks: learn 4 smart ways to scale numbers (K, M, B), add emojis, and switch formats — all while keeping your measures numeric and visuals clean. PBIX available at the end of this article 🥳 Introduction Many of us (I’m guilty 🙋‍♀️🙈) use the FORMAT() function to prettify/get the exact display in numbers you are seeking (like to show “K”, “M”, or “B”), integrate symbols (+, -, ↗️, ↘️), etc.But there’s a catch: once you use FORMAT(), your measure becomes te

How to build context-aware visuals that adapt to user filters — no static ranges, no loss of meaning. PBIX available at the end of this article! 🥳 🧭 Introduction I recently built an expense dashboard where one visual shows how invoices distribute across different amount ranges. The report was highly interactive — users could slice by Department , Category , Period , and more. With fixed bins (“$0–10K”, “$10–25K”…), the ranges quickly became meaningless when users drilled i

Because even your DAX deserves a little personality 😎 I f you’ve read a few of my previous articles, you’ve probably noticed it already...

Learn how to use Power BI’s new UDFs to simplify conditional formatting and standardize KPI colors across your dashboards PBIX available...

Fast, consistent DAX — packaged once, reused forever. Introduction Power BI recently introduced (in Preview) DAX User-Defined Functions...

Leverage core visuals and advanced DAX to deliver executive-ready insights 🎁PBIX available for download at the end of this article!...

A hands-on guide to calculating correlations, formatting visuals, and adding interactivity — no external tools needed. 🎁PBIX available...

A hands-on case study using Python and Isolation Forest — run entirely inside Power Query to flag suspicious employee expenses. 🎁PBIX...

A step-by-step guide to building interactive project timelines in Power BI using bar and column charts. 🎁PBIX available at the end of...

A step‑by‑step guide to designing stylish, custom‑looking area charts without custom visuals 🎁 PBIX available at the end of this...

How I used GPT-4 to extract themes, score sentiment, and build an interactive dashboard in Power BI 🎁 PBIX included at the end of this...

How I used Power Query and Python to build a reusable, customizable forecasting model — no Premium needed 🎁 PBIX included at the end of...