topic Topn N sorting for Stacked bar chart in Developer

Topn N sorting for Stacked bar chart

Mhnsan1113 — Wed, 04 Aug 2021 13:59:32 GMT

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

Re: Topn N sorting for Stacked bar chart

Anonymous — Fri, 06 Aug 2021 01:43:25 GMT

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

Re: Topn N sorting for Stacked bar chart

Mhnsan1113 — Tue, 10 Aug 2021 09:24:23 GMT

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

Re: Topn N sorting for Stacked bar chart

Anonymous — Fri, 13 Aug 2021 08:14:54 GMT

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