SOLVED! Pareto Chart with TIES In Power BI | Step-By-Step Tutorial | Part 2

This is the second part of the video on how to create a pareto chart in Power BI. This video shows you how to handle ties in Pareto % calculation. Ties in a Pareto chart are when the same rank appears more than once. Creating a Pareto analysis in Power BI is not difficult and this video will show you how to break down a complex DAX Pareto measure step by step.

If you haven’t watched the Part 1 video, here is the:    • How to Make Pareto Charts in Power BI...  

Power BI lets you create Pareto charts without the need for any other custom visuals. The process is very straightforward and should be easy to understand with simplified instructions.

For this video, I created a dummy data set of guest complaints for a fictitious restaurant chain. We will use a Pareto chart and the 80/20 principle to plot and analyze our data and find out the top few vital issues that are responsible for the majority of the complaints.

💚 Subscribe to this channel: https://www.youtube.com/c/excelfort?s...

----------------------------------------------------------------------------------
⏲ Video Timestamps

00:00 Introduction
00:39 Data Model and understanding the Pareto ties Issue
02:08 Creating Pareto % measure solving ties using RANKX - Solve ranking for duplicate numbers
13:46 Review the Pareto % measure
15:29 Apply conditional formatting to show Pareto in Lines and Stacked Column Chart
17:05 Ending
----------------------------------------------------------------------------------
⏬ You may download the completed PBIX file here:
https://excelfort.com/solved-pareto-c...
------------------------------------------------------------------------------------------------
👨‍🏫 For Instructor-led virtual training programs, visit:
https://excelfort.com/training/ or 📧 [email protected]
------------------------------------------------------------------------------------------------
🟢 LET'S CONNECT!

✔   / excelfort  
✔   / excelfort  
✔   / exce.  .
✔ Email: [email protected]
✔ Mobile No: 00966509791858

#powerbi #powerquery #msexcel #excelfort #powerbidesktop​ #powerbitraining​ #DAX