Skip to main content
Microsoft Idea

Power BI

Needs Votes

TopN applied to all levels of Hierarchy

Vote (13) Share
Ania's profile image

Ania on 04 Jan 2017 17:04:48

I would like to apply the topN function to the full level of the hierarchy. i.e. top 5 store sales, top 5 department sales, top 5 product sales, where the hierarchy consists of products, department and stores.

Currently you need to place a topN on each level causing the highest level to show only one value and not 5. In addition when drilling to the top all the filters disappear.

I have searched all over for this, so if this does exist, please advice.

Comments (1)
Ania's profile image Profile Picture

Sudhir Mehta on 06 Jul 2020 00:12:20

RE: TopN applied to all levels of Hierarchy

I'm also facing the same issue.. Microsoft team please have a look and share the results