Case Study - Top Quartile Reporting in Power BI using the PERCENTILE.INC() DAX Function скачать в хорошем качестве

Case Study - Top Quartile Reporting in Power BI using the PERCENTILE.INC() DAX Function

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(), use SWITCH() - wh...   ----------------------------------------------------- 🎓 Power BI Dashboard Training ----------------------------------------------------- 👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes! https://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! https://effectivedashboards.com/power... ------------------------- 📁 Resources ------------------------- 👉Access to the source PBIX files for my YouTube videos: https://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). https://effectivedashboards.com/data-...