Topn N sorting for Stacked bar chart

Question

Hi AllNeed help and support one issueIn Tableau there is feature of showing Top N for stacked bar chart as shown below by Business Unit &amp; By Company Codeeach have individual sliders. If I change 6 or 7 for Business Unit (BU) it shows 6 &amp; 7 respectivelyIf am applying same in powerbi , i am not getting the results. i used by creating table&nbsp;1) Rank by BU = GENERATESERIES(0, 20, 1)2 )&nbsp;Rank by BU Value = SELECTEDVALUE('Rank by BU'[Rank by BU])then went to main table and created(a)selectRanktopnumber. = IF(HASONEVALUE('Rank by BU'[Rank by BU]),MIN('Rank by BU'[Rank by BU]),20)(b)Rankby BU. = IF(HASONEVALUE(po_change[business_unit]),RANKX(ALL(po_change[business_unit]),[PO Line No Count],,DESC))(c)BU-RANK Final. = if ([(b)Rankby BU.]&lt;[(a)selectRanktopnumber.],1,0)Used the (c) in filters &amp; 1) as slicer (marked in yellow).&nbsp;&nbsp;&nbsp;&nbsp;Its not getting sorted instead of 2 i'm getting 4 business unit.Request if someone can help on the workaround&nbsp;&nbsp;Thanks in Advance&nbsp;

anonymous · Answer

Hi Mhnsan1113,
Can you please share a pbix file or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

mhnsan1113 · Answer

Hii am not able to attached the test pbix file. when clicked on insert is asking for url.how do i copy/paste the file.&nbsp;Please guide&nbsp;

anonymous · Answer

Hi&nbsp;Mhnsan1113,
You can upload it to your network driver and share the link here.&nbsp; 
Notice: please not attach sensitive data in your sample.
Regards,
Xiaoxin Sheng

Forum Discussion

Related content

Stacked Bar Chart Sort

Sorting a stacked bar chart

Dual Sorting for Stacked Bar Chart

Sorting stacked chart

Stacked Column Chart Data Labels