Pareto Chart

[gauravp]

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

[v-qiuyu-msft · Accepted 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:

Pareto Charting in PowerBI

Best Regards,
QiuyunYu