Forum Discussion
hb0135
3 years agoHelper III
Pareto Chart
Hi all,
Please help to create a pareto chart for below data
| Errors | Value |
| Label on Box | 11 |
| Assembly | 7 |
| Others | 7 |
| Spares | 7 |
| Packing | 7 |
| Visual | 4 |
| Coolant | 3 |
| Sticker on Tool | 3 |
| Blackening | 3 |
| Marking | 2 |
| Deburring | 1 |
| Dent | 0 |
| LP | 0 |
| Dent marks | 0 |
8 Replies
- amitchandakSuper User
hb0135 , if needed, Also add Error to order by (second)
Continue to explore Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs
- hb0135Helper III
Hi
After giving above solution I have tried then also not working please help if i am doing any thing wrong for creating Pareto chart
The Dax Measures i have created are
- hb0135Helper III
Hi
I want this to be done
what to do if same value in Jan column are repeatedfor eg- value 7 is repeated 3 times then how to create pareto chartif the values are different in column Jan i am getting Pareto Chart