KPIs are key to monitoring business performance, but in most cases, they do not tell the whole story.
This can now be overcome using reference labels and conditional formatting in the new card visual in Power BI and I show you how to maximise them in this video.
#powerbi #dax #PBICoreVisuals
📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/superstore-dataset/workspace/file?filename=Fact_Customer_Order.xlsx
https://data.world/deanchereden/superstore-dataset/workspace/file?filename=Dim_Date.txt
🔖c h a p t e r s 🔖
00:00 - Intro
00:38 - Overview
02:45 - Check your PBI version
03:14 - Load data
03:39 - Set up new card visual
04:01 - Add main measure to card visual
05:04 - Format call out value & label
06:57 - Format card layout & look
08:17 - Create a target measure
10:05 - Create a target difference measure
10:24 - Set up target reference label
14:29 - Create target var label with arrows
18:11 - Create a divider line in ref label
19:26 - Add additional reference labels
22:28 - Add conditional formatting
23:23 - Create the conditional format measure
28:34 - Conditional format reference labels
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4