Top N Hierarchy same at all levels

[Anonymous]

Hello All, 

I am trying to achieve Top 5 at all levels of the hierarchy in the table. Here is the link to access the PBIX file.

When I am applying Top 5 Level Hierarchy at the Level 1 on Filters Pane and drills it to the next level, it shows complete data which is not needed and filter pane doesn't allow to apply Top 5 on Level 2 but it has to be Level 2 Top 5 in Level 1.

How to implement this?

[v-yuta-msft · Accepted solution]

@Anonymous ,

Actually this can't be achieved using TOPN filter,  to achieve your requirement, I'm afraid you need to create addtion column to rank each level using dax, I would suggest you read third-party blog below about dynamic TOPN:

https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.