Creating a Pareto Chart in Power BI is not difficult and this video will show you step-by-step how to create one. You can then use this technique to apply the 80/20 rule in your own use case.
Power BI lets you create Pareto charts without the need for any other custom visuals. I’ll walk you through the process of making a Pareto chart in Power BI using native visuals in this video, and in the next video, I will show you how to deal with ties or duplicate values when building a Pareto chart.
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.