Show Targets and Highlight Variances With REFERENCE LABELS in Power BI New Card Visual

  Рет қаралды 1,080

Jason Davidson

Jason Davidson

Күн бұрын

Unlock the full potential of your Power BI dashboards in this easy-to-follow tutorial! Learn how to power up your Power BI card visuals by adding extra detail with reference labels.
In this video, I'll guide you through the simple steps to enhance your Power BI card visual, providing more context on the current performance against a backlog threshold target. This will not only improve the aesthetic of your dashboard but also its functionality.
🤔Why add Reference Labels?
Remember, "Context is king" in dashboard design. They are essential in quickly communicating if the current value is on or off target and by how much.
For those new to these concepts, backlog hours and work order thresholds are key metrics in monitoring maintenance management performance but the same concept can be used for any metric or KPI that has a target.
In this example, I'll demonstrate how to set these thresholds and use card visual reference labels to clearly show the threshold, the variance from the threshold, and also implement red conditional formatting if the value exceeds the threshold.
This red conditional formatting creates a stark contrast to the other more muted colours in the dashboard, effectively drawing the reader's attention to the values that require immediate action!
So, if you're looking to bring your Power BI dashboards to the next level, this tutorial might be useful for you.
Don't forget to like, share, and subscribe for more tips on making the most of your data visualisations - it's much appreciated and will help me out a lot.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Intro
01:27 - Add Card Visual
02:54 - Change Measure Titles
03:30 - Add Reference Labels
04:51 - Tidy up Reference Label Area
06:51 - Add detail to the reference Label
09:02 - Add conditional formatting
12:00 - Card Callout / Reference Label Spacing Adjustments
14:02 - Update Ref Label Divider Line and Background Colours
14:42 - Final update of the call-out/ref label spacing
--------------------------------------------------------------------------------------
🎥 Related Videos / Resources
--------------------------------------------------------------------------------------
See this video to find out how I designed the backlog by criticality card/navigation buttons.
Create Power BI Card Visuals That Act As Slicers Using New Slicer Visual
• Create Power BI Card V...
Maintenance Backlog Analysis Dashboard Revamp Playlist:
• Backlog Dashboard Revamp
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-...

Пікірлер: 2
@Tammy-o9q
@Tammy-o9q 2 күн бұрын
thank you for sharing this great video, I'm excited to update the KPI dashboard I manage. How do you insert the arrow icon into the measure?
@pedregundosouza4024
@pedregundosouza4024 6 ай бұрын
Hi, nice video, I have a chalenging question for you: How to send an email embedding a power bi table, but showing only new itens added to a table
Create Power BI Card Visuals That Act As Slicers Using New Slicer Visual
13:54
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Бискас
Рет қаралды 3,7 МЛН
Mama vs Son vs Daddy 😭🤣
00:13
DADDYSON SHOW
Рет қаралды 45 МЛН
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 184 МЛН
Задержи дыхание дольше всех!
00:42
Аришнев
Рет қаралды 3,7 МЛН
Variance Arrow in a Column/Bar Chart | Power BI Tutorials
6:12
Driven BI Data
Рет қаралды 1,8 М.
Power BI's Stunning New Card Visual Explained
24:54
Jason Davidson
Рет қаралды 3,7 М.
Master REFERENCE LABELS in Power BI | November  2023 Power BI Update
17:22
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Бискас
Рет қаралды 3,7 МЛН