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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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