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

Видео Create A Pareto Chart In Power BI Using DAX Function Combinations канала Enterprise DNA