Forum Discussion
paretto chart drill down possible?
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.
4 Replies
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 _ CaitlynIf 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 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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.