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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors