Create A Pareto Chart In Power BI Using DAX Function Combinations

I have previously discussed the Pareto Principle or the 80/20 rule that states that in a business 20% of the customers makes up 80% of the sales.

Using this rule and turning it into a chart and visualization is important as it helps you focus on the more important aspects of your business.

In this video, I am going to show you how to combine DAX formulas to create a Pareto Chart.

**** Video Details ****
1:50 - create a virtual table of the cumulative total with no dates
6:04 - create an all sales table
7:36 - combine DAX formulas of the two tables to create the Pareto chart
7:49 - use VARIABLES
8:50 - change the data in Pareto Chart (States) into percentage


**** Learning Power BI? ****
FREE COURSE – Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE – Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE – Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...


**** Related Links ****
Implementing The Pareto (80/20) Principle in Your Power BI Analysis - https://blog.enterprisedna.co/impleme...
Predicting When Will Your Customers Purchase Next w/ Power BI - https://blog.enterprisedna.co/predict...
New Customer Analysis Using Advanced DAX - https://blog.enterprisedna.co/calcula...


**** Related Course Modules****
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/uniq...
Solving Analytical Scenarios w/Power BI & DAX - http://portal.enterprisedna.co/p/solv...
Budgeting and Forecasting - http://portal.enterprisedna.co/p/budg...


**** Related Support Forum Posts****
Create A Pareto Chart In Power BI Using DAX Function Combinations - https://forum.enterprisedna.co/t/crea...
Testing The Pareto Principle (80/20 Rule) in Power BI w/ DAX - https://forum.enterprisedna.co/t/test...
Pareto Rule DAX Function - https://forum.enterprisedna.co/t/pare...
For more pareto queries to review see here - https://forum.enterprisedna.co/search...