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 into percentage
9:13 change visualization

***** 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 – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

Read More

Share This