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/ultimate-beginners-guide-to-power-bi FREE COURSE – Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download FREE – Power BI Resources - http://enterprisedna.co/power-bi-resources Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Implementing The Pareto (80/20) Principle in Your Power BI Analysis - https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/ Predicting When Will Your Customers Purchase Next w/ Power BI - https://blog.enterprisedna.co/predict-when-customers-will-purchase-next-advanced-power-bi-dax/ New Customer Analysis Using Advanced DAX - https://blog.enterprisedna.co/calculate-the-total-of-new-clients-youre-onboarding-every-month-advanced-dax/ ***** Related Course Modules***** Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios Solving Analytical Scenarios w/Power BI & DAX - http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax Budgeting and Forecasting - http://portal.enterprisedna.co/p/budgeting-and-forecasting ***** Related Support Forum Posts***** Create A Pareto Chart In Power BI Using DAX Function Combinations - https://forum.enterprisedna.co/t/create-a-pareto-chart-in-power-bi-using-dax-function-combinations/5114 Testing The Pareto Principle (80/20 Rule) in Power BI w/ DAX - https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459 Pareto Rule DAX Function - https://forum.enterprisedna.co/t/pareto-rule-dax-function/1802 For more pareto queries to review see here - https://forum.enterprisedna.co/search?q=pareto