Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

TopN functionality

October update has TopN functionality but it is not upto the mark.
Like how user can drag and drop the field / measure for TopN filter.
If user clear the filter then dragged field disappear, user can not add again measure again in filter section.
Could you please help me out here.
Community Champion
Community Champion

@Shubham I don't like how they implemented this also.


They have this tried-and-true product - the Excel Power Pivot Table - why don't they get any ideas from it?


Select a Field in the Pivot Table =>click on the Field Header => Value Filters => Top N...

(In fact clicking the field header also gives you so many other options we need - such as sorting at EACH level)


Value Filter - Top N....png



@Sean@Seth_C_Bauer - Sean I agree with you.. This is what I was asking about. If you clear the filter then "by Value" field is gone.

if user has read access then they cannot add it once again. also drag and drop is not easy for every user.

if we are giving them top N functionality then they dont want to add field again and again..

I think microsoft PBI team think about it again. I will open a support ticket and will update you.

Hi All,


I agree with you. I think it is better to use a dropdown box for the value selection in this scenario as Sean mentioned above. Could you also submit this request on Power BI Ideas? So that we can vote it up, and Power BI team will take good consideration about it and make this feature come sooner.Smiley Happy



@Shubham Are you talking about end users in the Service?

As a report author in the Desktop you have all the functionality to add/remove the filter settings.
If you are talking about end users in the Service interacting with the report then I would consider that "by design"... I'm creating a visual on TopN based on the criteria I want the end user to use. The fact that they can interact with Filters doesn't mean I want them saving or modifying the report. If you want to do that, share via a Content Pack or give them access to the dataset to build their own.

If they removed the filter, they can navigate back to the dashboard and into the report again and it should reset to the original filter set.

Looking for more Power BI tips, tricks & tools? Check out the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!