Forum Discussion

Mhnsan1113's avatar
Mhnsan1113
Frequent Visitor
5 years ago

Topn N sorting for Stacked bar chart

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

 

Need Help

3 Replies

  • Mhnsan1113's avatar
    Mhnsan1113
    Frequent Visitor
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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