Member-only story

My Best Power BI KPI Card (So Far 😅)

Isabelle Bittar
The BI Corner
Published in
8 min readJan 4, 2025
By Isabelle Bittar for KI Data Science

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

Introduction

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 contexts that push me to create unique visuals. Most of my clients are large enterprises, but in this case, it was a community gym ⛹️ that wanted a dashboard to track member engagement and identify potential churn factors.

What was especially exciting about this project was that they had image data of their members! And I REALLY wanted to use it — since I’ve rarely (never? 😅) had the opportunity to work with profile images in a real project.

In this article, I’ll explain the steps I followed to create this KPI card. It dynamically displays:

  • The percentage of members who went to the gym at least 3 times during the selected week.
  • The profile images of members with the most visits.

You can even hover over the images to see a detailed list of all members who attended 3+ sessions that week!

Anatomy of the KPI Card

Here’s an overview of how I structured the KPI card (including visuals, measures, and columns). As you’ll notice, most of the layout consists…

--

--

The BI Corner
The BI Corner

Published in The BI Corner

Empowering BI enthusiasts, The BI Corner aims to elevate practices & share top trends in analytics, UX, & UI. Join us in advancing BI through leading insights & cutting-edge research. #BICorner #Analytics #UserExperience #UserInterface

Isabelle Bittar
Isabelle Bittar

Written by Isabelle Bittar

Isabelle is a Montreal-based business consultant specialized in data science.

Responses (6)