Рет қаралды 3,305
In this video, I'll walk you through adding colour conditional formatting to 2 aspects of the new Power BI card visual.
The first will explain how to change the icon displayed in the new card visual, based on comparing it to a threshold value.
The second will explain how to dynamically change the colour of the accent bar, again based on comparing a given measure with a threshold value i.e. changing the accent bar colour to red if the maintenance backlog hours are above the threshold!
-- Central KPI Table --
I'll also explain how to create a table that contains the list of KPIs and their threshold values and refer to them in your conditional formatting DAX measure code.
This means all the thresholds are stored in one place and not hard-codded into a conditional formatting rule for each visual or the DAX code of each formatting measure. If the threshold values need to be updated then they can be updated in one place and the new value will cascade to the logic of the underlying conditional formatting calculations.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Introduction
01:17 - The Fx Button
02:16 - Image URL for Conditional Formatting
03:58 - Creating Images and Uploading URL Images
05:03 - Creating & Applying Cndf Measure
06:40 - Creating Thresholds Table
08:06 - Updating the Cndf DAX Measure
10:35 - Card Visual Accent Colour Formatting Measure
11:40 - Discussion on Colour and Contrast
12:40 - Adding Cndf Measure to Accent Colour
14:41 - Adding Dynamic Threshold Values to Sub-Heading
15:30 - Dynamic Threshold Value Text Measures
16:48 - Testing Changes To Threshold Values
-----------------------------------------------------
🎥 Related Videos & Pages
-----------------------------------------------------
New Card Visual Video 1 - Power BI's Stunning New Card Visual Explained
• Power BI's Stunning Ne...
New Card Visual Vide 3 - Fast-Track Creating Power BI Sparkline SVG Charts In the NEW CARD VISUAL Using Templates & ChatGPT
• Video
-----------------------------------------------------
🎓 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-...