Power BI Ideas Admin on 03 Oct 2014 07:12:28
Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
Administrator on 10 Jul 2020 16:04:36
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!
- Comments (264)
- Merged Idea (1)
RE: Top N Filters
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.
RE: Top N Filters
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
RE: Top N Filters
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!
RE: Top N Filters
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.
RE: Top N Filters
also page level filter
RE: Top N Filters
It will be nice to have option to suppress middle values in table. In summary we will have: top N records, suppressed "line" that can be expanded (show all records), bottom N records. Thanks!
RE: Top N Filters
Such a shame it was not implemented with TopN feature. Development team does not have any clue about analytics and charting?
RE: Top N Filters
To allow top N on each visual, being able to select the measure from which the Top N will filter the data.
Link with image as below:
https://community.powerbi.com/t5/Report-Server/Idea-for-visual-Top-N-on-visual-Typing-here-as-no-images-can-be/m-p/905694#M12718
RE: Top N Filters
Actually it is not possible to use a WhatIf parameter for a TopN filter.
This mean that the user is not able to dynamically set the amount of rows in the Visual filtered by a TopN.
This should not be a big deal to add this feature.
Thank you
Regards
Salvatore
RE: Top N Filters
Please, we need this