How to Build Dynamic KPI Cards in Power BI Using Only Core Visuals

Leverage core visuals and advanced DAX to deliver executive-ready insights

By Isabelle Bittar for KI Data Science

🎁PBIX available for download at the end of this article!

Introduction

Lately I’ve been working on several healthcare projects. One executive dashboard I built focused on operational efficiency and resource optimization. It fitted on just a couple of report pages and relied on just a few KPI cards — like the one in the cover image — to surface dynamic highlights, with a small chart underneath to show unit-level detail. Users can click different highlights to pivot the chart to the relevant topic.

Here’s a short demo video to see the KPI card in action:

I built all of this with Power BI core visuals. The Key Observations section is powered by the Button slicer (the new slicer type) and a few DAX measures that (1) compute the latest 7-day metrics, (2) presents key insights, and (3) swap the chart measure based on the selected highlight…