Forum Discussion
Top N Hierarchy same at all levels
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?
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.
1 Reply
v-yuta-msftCommunity Support
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.