One UDF, All Your KPI Colors 🎨: 3 Steps in Power BI (PBIX Included!)

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

By Isabelle Bittar for KI Data Science

PBIX available at the end of this article 🥳!

Introduction

User Defined Functions (UDFs) are still very fresh in Power BI — and as we experiment with them, new use cases are popping up everywhere.

Building on my previous article ⚡Power BI’s New User Defined Functions: 10 Must-Have You’ll Use in Every Report, here’s an additional UDF I’ve started using a lot: Color Indicators.

Why? Because almost every dashboard has some form of conditional color formatting. Whether it’s showing KPIs, trends, or exceptions, consistent colors make your insights clearer and more professional.

This idea actually came from the community (thank you Sumesh for your comment 👋) and from my own projects where clients expect intuitive, color-coded indicators.

Here is a short demo of the dashboard presented in the cover image: