Рет қаралды 11,405
Learn how to set up a Power BI column chart that calculates the top quartile performers in a given data set.
I'll cover 2 approaches. The first is a quick and easy method using the Power BI Analytics features.
In the second approach, which is more flexible, I'll use the PERCENTILEX.INC() function to calculate the top quartile performers.
I'll also explain how to set up a neat feature that allows you to select the top, middle, or bottom quartile performers and dynamically highlight these on the column chart. It highlights the selected quartile by changing the colour of the columns, while also displaying a percentile threshold line.
👍Tip: This is a longer video so try increasing the playback speed to speed up your learning.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Introduction
00:52 - What is the 'Top Quartile'?
04:10 - How a Percentile Value is Calculated?
06:08 - Quick Approach - Adding a Top Quartile Line Using Power BI Analytics Feature
09:44 - Requirements for Dynamic Conditional Formatting of Top Quartile
11:03 - Overview of PERCENTILEX.INC()
14:02 - Creating the Percentile Calculation Measure using PERCENTILEX.INC()
19:45 - Dynamically Highlighting TQ - Step 1: Create a Selection Slicer
23:25 - Dynamically Highlighting TQ - Step 2: Link Selection Slicer to Percentile Measure
25:00 - Dynamically Highlighting TQ - Step 3: Create Column Colour Conditional Formatting Measure
37:34 - Adding a Dynamic Chart Header That Includes Percentile Threshold Value
42:03 - Summary of Video
-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
QT#21 - Stop using IF(), use SWITCH()
• QT#21 - Stop using IF(...
-----------------------------------------------------
🎓 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 really do help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my KZfaq videos:
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-...