Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
109 | |
98 | |
93 |