Topn N sorting for Stacked bar chart

[Mhnsan1113]

Hi All

Need help and support one issue

In Tableau there is feature of showing Top N for stacked bar chart as shown below by Business Unit & By Company Code

each have individual sliders. If I change 6 or 7 for Business Unit (BU) it shows 6 & 7 respectively

If am applying same in powerbi , i am not getting the results. i used by creating table 

1) Rank by BU = GENERATESERIES(0, 20, 1)

2 ) 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.]<[(a)selectRanktopnumber.],1,0)

Used the (c) in filters & 1) as slicer (marked in yellow). 

   

Its not getting sorted instead of 2 i'm getting 4 business unit.

Request if someone can help on the workaround

 Thanks in Advance

[Mhnsan1113]

Hi

i am not able to attached the test pbix file. when clicked on insert is asking for url.

how do i copy/paste the file.

Please guide

[Anonymous]

Hi @Mhnsan1113,

You can upload it to your network driver and share the link here. 

Notice: please not attach sensitive data in your sample.

Regards,

Xiaoxin Sheng

[Anonymous]

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  

Regards,

Xiaoxin Sheng