Top N Filters

[pbiideas1]

Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'

[James_Watts]

Editing dataflows can be quite painful. What would help would be if information about them - and processing steps - could be saved along with the dataflow, so that when opening one to edit, rather than having to wait for processing to finish, it opened with sample data immediately.

[psn1]

Hi, When using "Top N" feature on visuals, please make it possible to add "Other". So selecting "Top N" based on Sales, it would be possible to select "Group rest as Other". I can there are several workarounds with ranks, but I don't find it very dynamic with slicers etc. This would be gamechanger!

[nishalit]

I'm very pleased to say we've just released the ability to add TopN filters to your visuals in our October update. More details here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#analytics Please keep submitting ideas and suggestions for other things we can do in this area!

[nishalit]

En Power BI al seleccionar los Top N, elimina el resto de items; esto es un problema porque sólo tenemos un panorama parcial de la información. En Oracle BI existe la posibilidad que al seleccionar los TOP N, tenemos la opción que los items que NO ESTAN en los TOP N, se agrupen en Resto u Otros (según como el usuario desea llamarlo) y además tienes la opción de colocar el Resto u Otros en la posición N+1, esto es una maravilla porque podemos ver en un sólo cuadro cuanto representa los TOP N

[nishalit]

Top n Filter should be allowed on multiple fields and/or against multiple facts. For example - show top 10 sales people and lowest 10 products (both facts should be true to be displayed). As of April 2017, only one top n filter is allowed, so I'm exporting data to Excel for reporting. Also, wish Excel could use my .pbix file as a data source for the PowerPivot data model - then i could easily work with any of the data (including all the measures). Power BI is a fantastic tool, but still needs Excel at times.