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...

🎁 PBIX included at the end of this article! I get really excited when I get to develop Python visuals in Power BI. A whole world of...

Because even the most boring tables deserve great design 🎁 PBIX included at the end of this article! Adding on to my previous article on...

Step-by-step walkthrough (PBIX included!) So, I’ve written about this before, but I recently figured out a better workaround for...

How the March 2025 update makes report formatting faster, cleaner, and more collaborative 🎁 PBIX and JSON files available for download...

Last year, I had the chance to work with a variety of different clients, and I find this so enriching because it exposes me to different...

Power BI tables are amazing. They offer many customization options through various methods. While I often rely on SVG measures/columns to...