cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Regular Visitor

## 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

1 ACCEPTED SOLUTION
Community Support

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)

Reference:

Pareto Charting in PowerBI

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support

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)

Reference:

Pareto Charting in PowerBI

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors