Forum Discussion

Helper I

2 years ago

Solved

paretto chart

hi all need help, spent alot of time without success( i have: table fact_sales column: employee_id (link to dim employees) date_id (link to date dim month and year) client_id (link to c...

Need Help

lbendlin
2 years ago
Our June numbers disagree. Likely a rounding issue.

pareto_sample.pbix42 KB
lbendlin
2 years ago
Your new table has negative quantities. You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.

pareto_sample.pbix1.2 MB

antonio_wurth

Helper I

2 years ago

lbendlin

thank you for your reply

link to sample data

https://1drv.ms/f/s!Asg9-7-728LO1DmJtLc7BUgYnZun?e=OMJ6Gz

i attached excel with sample data and step by step calculation

and pbix file only with sample data uploaded

thank you

lbendlin

Super User

2 years ago

Our June numbers disagree. Likely a rounding issue.

pareto_sample.pbix42 KB

antonio_wurth
Helper I
2 years ago
amaizing
thank you!!!
antonio_wurth
Helper I
2 years ago
lbendlin
i've replaced dataset with more real/full fact table
and now we are not matching(

i've uploaded on onedrive
https://1drv.ms/f/s!Asg9-7-728LO1DmJtLc7BUgYnZun?e=OMJ6Gz

can you check please?
- lbendlin
  Super User
  2 years ago
  
  where do you see the problem?
  - antonio_wurth
    Helper I
    2 years ago
    In xlsx file I attached
    With manual calculation
    Numbers are different

Forum Discussion

paretto chart

Related content

Line chart

Comparison Chart

Sankey Chart

chart suggestion

Run Charts/p-charts in Power BI?