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 Chart is not difficult and this video will show you how to break down a complex Pareto DAX measure step by step for you.
If you haven’t watched the Part 1, here is the LINK
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.
Hope this article/video was helpful to you? Please leave your comments, suggestions or questions in the comments.
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s Saudi Arabia as the Head of ERP and Business Intelligence. He is interested in everything data-related, he likes to share his passion and knowledge with the data community.