Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have been trying to get drill down functionality in paretto analyis but couldn't get correct result.
i have written a logic at product level sucessfully . But i want product line first and then if i click the product level is should go down to product .
how to write a dax logic to get drill down functionality in paretto analysis.
I have attached a pbix file link .
Please help
Area Code | Date | Month | Year | Product | Product Line | Product Type | Region | State | Territory Size | Type | Inventory | Profit | Sales | Year |
970 | 01-Jan-12 | 01-Jan-12 | 2012 | Decaf Irish Cream | Beans | Coffee | Central | Colorado | Major Territory | Decaf | 821 | 101 | 234 | 2012 |
970 | 01-Jan-12 | 01-Jan-12 | 2012 | Colombian | Beans | Coffee | Central | Colorado | Major Territory | Regular | 623 | 68 | 190 | 2012 |
970 | 01-Jan-12 | 01-Jan-12 | 2012 | Chamomile | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 1091 | 99 | 341 | 2012 |
970 | 01-Jan-12 | 01-Jan-12 | 2012 | Mint | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 336 | 33 | 140 | 2012 |
970 | 01-Feb-12 | 01-Feb-12 | 2012 | Caffe Mocha | Beans | Espresso | Central | Colorado | Major Territory | Regular | 449 | 80 | 189 | 2012 |
970 | 01-Feb-12 | 01-Feb-12 | 2012 | Chamomile | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 1073 | 99 | 340 | 2012 |
970 | 01-Feb-12 | 01-Feb-12 | 2012 | Lemon | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 427 | -3 | 129 | 2012 |
970 | 01-Feb-12 | 01-Feb-12 | 2012 | Green Tea | Leaves | Tea | Central | Colorado | Major Territory | Regular | 618 | 30 | 100 | 2012 |
970 | 01-Mar-12 | 01-Mar-12 | 2012 | Decaf Espresso | Beans | Espresso | Central | Colorado | Major Territory | Decaf | 541 | 54 | 180 | 2012 |
970 | 01-Mar-12 | 01-Mar-12 | 2012 | Colombian | Beans | Coffee | Central | Colorado | Major Territory | Regular | 603 | 69 | 193 | 2012 |
970 | 01-Mar-12 | 01-Mar-12 | 2012 | Lemon | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 421 | -4 | 125 | 2012 |
970 | 01-Mar-12 | 01-Mar-12 | 2012 | Darjeeling | Leaves | Tea | Central | Colorado | Major Territory | Regular | 325 | 16 | 129 | 2012 |
970 | 01-Apr-12 | 01-Apr-12 | 2012 | Colombian | Beans | Coffee | Central | Colorado | Major Territory | Regular | 593 | 63 | 178 | 2012 |
970 | 01-May-12 | 01-May-12 | 2012 | Chamomile | Leaves | Herbal Tea | Central | Colorado | Major Territory | Decaf | 1156 | 83 | 298 | 2012 |
970 | 01-Jun-12 | 01-Jun-12 | 2012 | Colombian | Beans | Coffee | Central | Colorado | Major Territory | Regular | 574 | 68 | 190 | 2012 |
970 | 01-Jun-12 | 01-Jun-12 | 2012 | Earl Grey | Leaves | Tea | Central | Colorado | Major Territory | Regular | 1028 | 27 | 117 | 2012 |
970 | 01-Jul-12 | 01-Jul-12 | 2012 | Decaf Irish Cream | Beans | Coffee | Central | Colorado | Major Territory | Decaf | 1007 | 139 | 312 | 2012 |
970 | 01-Jul-12 | 01-Jul-12 | 2012 | Colombian | Beans | Coffee | Central | Colorado | Major Territory | Regular | 564 | 71 | 199 | 2012 |
tot = sum(Sheet1[Sales])
Rank = RANKX(all(Sheet1[Product]),[tot])
Paretto % = DIVIDE([cumulative],CALCULATE(sum(Sheet1[Sales]),all(Sheet1[Product])))
i have written the paretto percentage for product type,
now how to get the product level paretto in same chart
if we click the product level then it should drill down to product type in the same chart is it possible.
Hi @Anonymous ,
I made several attempts on the sample you provided but unfortunately it did not work, you may contact the engineers at Power BI Custom Visual to see if they can help you.
Contact:Custom Visual Support
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please check if this article will help you with your question:
How to Create Pareto Chart in Power BI
I will continue to try to use the sample data you provided to complete your request, and I will give you feedback here in a timely manner if there is progress.
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for replying , please check the onedrive link https://1drv.ms/u/s!AqEOeVnvlFkLbjG3pqYBOX2oVL4
to have understanding about the requirment. explaining again product type is level 1 and product should be level 2
if i click the product type it should drill down to product in paretto analysis
every level is should have paretto analysis
Hi super users anyone can help me on this ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |