Top N + other at all levels in a hierarchy

[Anonymous]

Hi,

What I would like to have is a slicer that will show the Top N (i.e. 5, 10 all) plus the others along with their sales numbers at all levels in a hierarchy so if I start with the Top 5 Categories and drill down to Product Groups it will then show me the Top 5 Product Groups but I can use the slicer to change to the Top 10 for example.

I have the below structure and I am using the hierarchy in the "Item PG and Brand" table along with a calculated measure on Gross Sales which is below.  The join between the "Sales Data (Combined) and "Item PG and Brand" tables is Product Key to Key

Gross Sales = (SUM('Sales Data (Combined)'[Sales Gross]))

While I can use the Top n filter in a visual it doesn't show me the Others and from some of the other posts, I can't get the solutions to work with a hierarchy.  Any help would be gratefully received.

Thanks,

Mike

[v-chuncz-msft]

@Anonymous 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Dynamic-Top-N-and-Others-category/m-p/614566#M292949

[Anonymous]

Hi @v-chuncz-msft ,

Thanks for the reply, but how would the solution work with a hierarchy?  looking through the post, it looks like it would work for just customer name, but how does it deal with a hierarchy?  I'm keen to see only my Top n Categories and if I drill through from here I should then see the Top N Product Groups and if I select one of those I should then see the Top N Brands.

thanks,

Mike

[amitchandak]

One of the workaround is that you create different pages with TOP N and allow drill across pages. 

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through