Creating A KPI Scorecard Report: Part 1

UPDATED TECHNIQUE 🌟

In this multi-part series you'll learn techniques utilizing DAX, custom visualizations, and design techniques to create a great looking KPI Scorecard report in Power BI.

Part One will show you how to create the first set of KPI cards as well as the title card for each metric.

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Content Intro
1:00 - Start of Demo
3:12 - Creating Metric Name Card
5:52 - Creating Store Rank Card
9:40 - Creating Total Value Card
10:15 - Creating Monthly Average Card
11:20 - Creating Latest Month Card

Part 2 of the series can be found here:

Part 3 of the series can be found here:

Part 4 of the series can be found here:

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[kishoreyc]

You Inspire me to take a leap of faith and plunge confidently into the unknown....
Building My project dashboard and feeling happy that i could get these similar measures working for me aswell. I'll take this to the next level.

[BIElite]

Awesome video! Very clean and conveys a lot of information. I will be coming back to this and your future parts when I need to build out a scorecard

[zakirhossain]

SIMPLY OUTSTANDING! Very advanced level creative video.

[Nick.Anselmo]

Nice job. Very good walkthrough. Looking forward to other parts.

[junaidmalik]

A very clear informative, use full video. Thankyou for creating this from scratch . This way uts v much helpfull.

[sirknightzjr]

Great video. I learnt a lot from it. 1 silly question though. How did you get the 3 bars at the top of any card or chart you selected? Its has this extra spacing at the top for each box selection you made. I find that really useful to help select a card/chart especially for tables without accidentally clicking on a column and sorting it.

Appreciate your sharing for this.

[llsnkpw]

I like your videos, thank you and go on.

[KenLoewen]

Really enjoyed this video. Would setting up a theme file be practical for a report of this type? It seems as if you're changing many of the formats, especially of the cards, in a consistent manner.

[lavanyavijay]

Thanks a lot. How can I get this dataset?

[alexandreletourneux]

Great video and series !
In your website you present the KPI Scorecard Report differently through a matrix.. How do you manage to show different metric details (for e.g. columns Rank, Total Value, etc.) per each row ? Using UNION fx or a grouping fx ?

[mammifero]

Great!
could you explain how you have created the "DAX Measures" Table ? thanks

[bwbrown]

What would be the reason I would not get "1" on a rank when NO store (slicer) activated/picked? I have 3 KPIs, my Sales is a 1 of 391, the other are 190 of 391, & and 186 of 391 even when no slicers or filters are running ... Any help would be great :|

[shoaibahmedkhan]

The color range I have in my power BI is different. How do you change it?