Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Syndicate_Admin
Administrator
Administrator

How to disable TOP N filter without losing field settings?

Good!

I have a table on which I want to make a filter of TOP N starting from a measurement such that:

gerardcanals_0-1631715418990.png

I am interested in keeping the filter preconfigured in this way, so that users can put the TOP N they prefer (10, 2, 5, 6, etc.).

The problem I find is that this setting does not apply and I have to put a default value yes or yes. Then, if I decide to delete the filter, the field settings also disappear and I have not been able to find a way to link it again from the display mode of power BI service, but I have to switch to the edit mode to add it.

I have already contemplated the idea of putting a very large number, but the maximum is 1000000 and that does not assure me that at some point the data will be affected (I have totals that sometimes will be required to consult without top N).

Do you have a solution to this problem?

2 REPLIES 2
amitchandak
Super User
Super User

@Syndicate_Admin , If a filter pane is available, the user can change it easily and refer back with a refresh. So you can save it with a large value, if that can work for you.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello!

Thank you for answering so quickly, but I just think that option I already commented:

"I have already contemplated the idea of putting a very large number, but the maximum is 1000000 and that does not assure me that at some point the data will be affected (I have totals that sometimes will be required to consult without top N)."

Is there no other option?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors