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

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Top N Filters

Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
Status: Completed
Comments
vinicius_marian
New Member
We really need this! Thanks.
Justin_Beelock
New Member
calculates the top N rows
ahamid_osd
New Member
allow to display top N row and collapse others under one row, with custom number N and custom field. Thanks
mikejarod
New Member
Please add this. The others category should also be used to filter other visuals. Workaround: https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
aswanthrajeev
New Member
Please add feature: 'Sort by value (ascending/descending)' in Visual level filters. Currently, the 'Visual level filter' feature allows me to sort items by name only, and not by value. Example to demonstrate: When I have my expense report, I would like to filter out my Top N items. Currently, these Top N items can be sorted only alphabetically. Whereas, I would like to have a feature where the Top N items can be sorted in either ascending or descending order of the "values" of the items.
jggallas1
New Member
Please add TOPN with rest in Others
robin_golding
New Member
Slicer that allows for top n e.g. 10, 50, 100 etc. and not at page filter.
Kevin_OBrien
New Member
The Top N function is great but you need to add the ability to add "All Other" and Overall Total to capture the full way in which folks look at data. Even better would be to add automated but adjustable functionality so you could have Top N / Next X / Next Y / Next Z / All Other / Overall Total. Functionality needs to be sensitive to slicers and cross filtering as well as additional metrics in the table.
fbcideas_migusr
New Member
Top N and All other Provide the ability to display 'everything else' on one row when using the Top N filter in a visualization. This is a standard reporting view for a lot of people in our company and we have to use workarounds to get it to display, but then it can't be filtered or drilled into without causing all sorts of messy displays.
fbcideas_migusr
New Member
Avi Singh shows a workaround here https://www.youtube.com/watch?v=wKfPS1yZfE0