Forum Discussion
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 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
Our June numbers disagree. Likely a rounding issue.
Your new table has negative quantities. You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.
13 Replies
- lbendlinSuper User
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-Forum/ba-p/963216
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/1447523 - antonio_wurthHelper I
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
- lbendlinSuper User
- antonio_wurthHelper I
amaizing
thank you!!!