Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi I want to make Pareto Chart. I have around 8 to 9 columns which get the data from number 0 to 6. Therefore, I wanted to make a pareto chart for those 8 columns category. So, It would be helpful if you could please let me know how can i make a pareto chart so that everytime the number is more than 0 it gets counted and then, we can make a pareto chart.
Sincerely,
Gaurav Paul
Solved! Go to Solution.
Hi @gauravp,
Based on my understanding, you have 8 columns, each column has 0-6 values. You can to count value for each column when values more than 0. Then use counted vales to create Pareto chart, right?
Assume the sample data table like below:
1. Select all columns, then click Unpivot Columns.
2. Filter out value 0 from Value column.
3. Click Group By, return count values.
Apply the change, back to the report, create a calculated column like below:
Cumulative % = var CumulativeCount = SUMX(FILTER('Table2','Table2'[Attribute]<=EARLIER(Table2[Attribute])),'Table2'[Count])
var Total=CALCULATE(SUM(Table2[Count]),ALL(Table2))
return
DIVIDE(CumulativeCount,Total)
You can download attached pbix file to see if it meet your requirements.
Reference:
Best Regards,
QiuyunYu
Hi @gauravp,
Based on my understanding, you have 8 columns, each column has 0-6 values. You can to count value for each column when values more than 0. Then use counted vales to create Pareto chart, right?
Assume the sample data table like below:
1. Select all columns, then click Unpivot Columns.
2. Filter out value 0 from Value column.
3. Click Group By, return count values.
Apply the change, back to the report, create a calculated column like below:
Cumulative % = var CumulativeCount = SUMX(FILTER('Table2','Table2'[Attribute]<=EARLIER(Table2[Attribute])),'Table2'[Count])
var Total=CALCULATE(SUM(Table2[Count]),ALL(Table2))
return
DIVIDE(CumulativeCount,Total)
You can download attached pbix file to see if it meet your requirements.
Reference:
Best Regards,
QiuyunYu
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |