Forum Discussion

gauravp's avatar
gauravp
Regular Visitor
9 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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