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.
💚 Subscribe to this channel: kzitem.info?s...
⏲ 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
----------------------------------------------------------------------------------
⏬ You may download the completed PBIX file here: excelfort.com/how-to-make-a-p...
------------------------------------------------------------------------------------------------
👨🏫 For Instructor-led virtual training programs, visit:
excelfort.com/training/ or 📧 info@excelfort.com
------------------------------------------------------------------------------------------------
🟢 LET'S CONNECT!
------------------------------------------------------
✔ / excelfort
✔ / excelfort
✔ / excelfort
✔ Email: info@excelfort.com
✔ Mobile No: 00966509791858
#excelfort #powerbi #msexcel #powerquery #powerapps #data #powerbidesktop #powerbitraining #DAX
Негізгі бет How to Make Pareto Charts in Power BI | Step-By-Step Tutorial | Part 1
Пікірлер: 48