How to Make Pareto Charts in Power BI | Step-By-Step Tutorial | Part 1

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.

⏲ Video Timestamps
----------------------------------------------------------------------------------
00:00 Introduction
00:50 Introduction to the Data Model
02:25 Building the Pareto % measure calculation
10:03 Applying conditional formatting
10:59 Adding a Pareto % parameter
14:10 Ending
----------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------
👨‍🏫 For Instructor-led virtual training programs, visit:
------------------------------------------------------------------------------------------------

🟢 LET'S CONNECT!
------------------------------------------------------
✔ Mobile No: 00966509791858

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

[sreyabhowmick]

Really helpful videos, I will be following you BI videos from now on! thank you

[fart_restoration]

you just saved my life with this! thank you!!!!

[ranis]

This is excellent. I just implemented this on a report and it works great. Thank you again.

[remi]

This video was a huuuge help to me. Thanks a lot and great job.

[pesalsa]

one of the best video, pareto is one the best tool . Thx so much !

[eLcHiNoChannel]

Great explanation! I was reluctant to use an external visualization... not only this video kept me from doing it, but it also taught me a great deal about DAX. I have a quick question, in my use case I have certain "categories" I don't want to bring into the visual because they have 0 of the "count" measure. The ALLSELECTED brings them all.

Any ideas on how to limit the ALLSELECTED to only the categories where the count of complains is ">0"?

[minsubchoi]

Your DAX skill is outstanding. Please keep up this great work! :) One Q; Let's say I have another detail table by complaint below Pareto chart. How do I make only highlighted complaints from Pareto chart are shown up in that detail table? In other words, I want Pareto chart to function as filter in other table without having to select each visual on Pareto.

[vivekmmurali]

Great Video. Quick question - Let’s say I want to display the total number of complaints and their corresponding cumulative count that is below the threshold in a card visual. Say for e.g there are 4 complaints and 400 instances of those complaints. Is this possible?

[powerflower-rr]

hi there, that's excellent; any hints what to do if 'complaints' (facts) are stored in one table and their `categories` (dimension) in the another one?

[lionels]

Good day
Thanks for your quality videos
Do you know why sometimes the pareto % is decreasing before reaching 100%?

[ElricherRM]

Hi There, awesome video Sr!!
Question: It is possible to add a parameter slicer so i can chose how many itens will appear on the graphic?

Thank you for the video!

[michalhofirek]

Perfect explanation - however i work with both large and small values (max of count is in milions and min is in single counts below 10). Meaning, that the percentage representation is extra small and if pareto threshold is set to 100%, then some of the values slip anyway. I tried to modify Pareto Threshold parameter - GENERATESERIES from smaller number with smaller increment, but there is limitation, that increment cannot be smaller than E-6. Is there any workaround??

[anuj]

Hi, this is an excellent video on pareto. I need a help, I need to create a measure which counts the number of complaint type based on pareto threshold parameter used in your video. So if order mix up and website not working properly come up with <= 50% I want the count measure to return =2

[suanpingguo]

Thanks for the video. At 2:36, how did you add 2-4 multiple empty rows to type command? thanks.

[mateushfa]

Very nice, thanks. How to work with same number in complaints category?
Example more than one category of complain with same count.

[suanpingguo]

This video helps a lot. Question, if the data is aggregated, does any code need to be changed?

[Geilisa]

How are you creating your Complaint Count measure?

[ethankim]

Just wondering is there any solution if several categories have the same count?
Thank you.