top of page
Search

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

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

ree

🎁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. Because everything is DAX-driven, the card automatically responds to data refreshes and slicers/filters (e.g., Role).

Below is a summary of the key components of the KPI card:


Anatomy of the KPI Card

ree

In the following article, I will take you through step-by-step on how I got this to work in Power BI. I will focus mostly on the Key Observations section since it’s the most complex part of the KPI card.


 
 
 
bottom of page