Forum Discussion
Pareto Chart
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
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
1 Reply
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