paretto chart

[antonio_wurth]

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 clients dim)
product_id (link to dim products)
amount

slicers: users can filter by:
a) employee_id(linkto dim employees)
b) product_id (link to dim products)(users can choose category)

i need to receive matrix like that:

years and months - static(last 2 years)

rows:

a) years
b) % - category of sales share 50% of sales, 80%, 90% 100%

columns: months

value:
distinct products


help please, thank you

[lbendlin · Accepted solution]

Our June numbers disagree. Likely a rounding issue.

[antonio_wurth]

@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 · Accepted solution]

Our June numbers disagree. Likely a rounding issue.

[antonio_wurth]

@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]

where do you see the problem?

[antonio_wurth]

In xlsx file I attached

With manual calculation

Numbers are different

[lbendlin · Accepted solution]

Your new table has negative quantities.  You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.

[antonio_wurth]

now number are corerct, thank you again!!!

but i'm getting an empty matrix

when adding year to rows

also subtotals are empty as well

i'm trying to buid table like that

hrlp please, thank you

[lbendlin]

Please provide sample data that fully covers your issue.

[antonio_wurth]

that the file you last send me

https://1drv.ms/u/s!Asg9-7-728LO1D8Jf6hseNtwektC?e=JAcONU

when add calendar_year to rows(before category) - chart is empty

[lbendlin]

Works for me.  Did you expand the rows?

[antonio_wurth]

yes, now its perfect

thank you again!!!

[antonio_wurth]

amaizing

thank you!!!

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...