2026 Week 45 | Power BI: Big Numbers and Key Point Indicators

/ Power BI, Workout Wednesday / By

Introduction

Key Point Indicators and Big Numbers; whether you are building them on a daily basis or it’s your first time, we could always do with some inspiration.

In this weeks challenge we are exploring some of those options, and will hopefully be a good resource to have in for future Reports.

There are quite a few Measures to write, therefore I’ve uploaded a starter file to get going with, good luck!

The solution file can be found ⬇️ (no video this time due to the excessive amount of calculations it quickly turned into an hour long video, apologies.)

Dataset

The Starter Report with a pre-build data model can be obtained from GitHub.

https://github.com/Imba456/Workout-Wednesday-for-Power-BI/blob/main/reports/2026%20W45%20Big%20Numbers%20and%20Key%20Point%20Indicators%20-%20Starter.pbix

If you’re feeling adventurous and want to create the report from scratch, the data for this challenge can be obtained from GitHub.

https://github.com/Imba456/Workout-Wednesday-for-Power-BI/blob/main/datasets/2026%20Sample%20Superstore%20Fabric.xlsx

Requirements

We’re splitting up the KPIs and BNs into different visuals and date comparisons. Good | Bad trends are colored with #27187E | #FF8600 respectively.

Current Year/Previous Year + Card Visuals:

  1. CY/PY Sales;
    1. one card
    2. four different measures
  2. CY/PY Profit ratio;
    1. three cards
    2. three text boxes
    3. one shape
    4. five different measures (one for the shape’s color)
  3. YTD Returned Orders
    1. one card
    2. four different measures

Month to Date vs. Same Period Last Year KPIs:

  1. MTD Sales vs. Last Year
    1. one KPI
    2. three different measures
  2. MTD Profit Ratio;
    1. one KPI
    2. one Area Chart
    3. two text boxes
    4. one shape
    5. five different measures
  3. MTD Returns;
    1. one KPI
    2. one Bar Chart
    3. one text box
    4. one shape
    5. six different measures

Sales Mix:

  1. Running Total Sales | CY PY;
    1. one line chart
    2. three cards
    3. one text box
    4. four different measures
  2. MTD Sales;
    1. one line chart
    2. one KPI
    3. three different measures
  3. Current vs Last YTD Sales by Category;
    1. one column chart
    2. three different measures

Use the slicer to keep an eye on the timeframes displayed to figure out how the values should respond and what colors change.

Share

After you finish your workout, share on social media using the hashtags #WOW2026 and #PowerBI. 
On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social. 
On LinkedIn, tag @RobbinVernooij

Solution

Download the file from the data stories gallery