Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Fowmy

How To Make A Pareto Chart In Power BI | Step-By-Step Tutorial | Part 1

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 about 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 the YouTube channel 

Hope this article/video was helpful to you? Please leave your comments, suggestions, or questions in the comments. 

 

 

 

Comments

Great video, @Fowmy ! 

Thanks a lot for sharing, it worked perfectly for me.

Anonymous

Hello Community,

 

I have a new requirement. I have desiged my pareto chart well and good but with in my requirement, I was asked to display the percentage of projects that meet 80% values and should display it as a card value. Any help regarding this.

 

Thanks in advance.

Hi @Anonymous, I might be able to help with your specific need. I just did a blog on Medium regarding a single KPI for the percent of projects (categories) that account for 80% of usage.  It uses the pareto principles outlined in the video here, but a few steps further to get the specific percentages that are still dynamic. 

Anonymous

This video very awesome!!!🤗

Hello,

 

This works great except for one issue. When two or more columns have the same value, it doesn't seem to add the columns beyond the first one. It looks like it just ignores the other colums of equal value. Any advice to fix this?

 

Thanks,

 

Jason 

 

Edit to add: it actually will add all the columns with the same count at once. For example, if you have two categories, each with 16 complaints, the SUMX expression will increase by 32. It doesn't show each columns contribution to the pareto curve individually. 

 

Additional Edit: I found the part 2 of this video that addresses when values are tied. Now my chart works perfectly. Thanks!

@JasonFurtner 

Please watch the 2nd part of this video: https://www.youtube.com/watch?v=8aDSztj9pmU

 

Thanks

Fowmy