Top n filter
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.
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!
James Watts commented
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.
also page level filter
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!
Such a shame it was not implemented with TopN feature. Development team does not have any clue about analytics and charting?
Marcelo Silva commented
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:
Salvatore Cagliari commented
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.
Lucas Souza Ferreira commented
Please, we need this
Aashish Jagdale commented
Can we have top / bottom N filter just above the visual in the report page for easy navigation for selection of Top / Bottom N filter. This feature is available in Tableau so that people migrating from Tableau to Power BI should have the same experience instead of selecting the visual and navigating to the right filter section for applying filter. Thanks in advance.
Avi Singh shows a workaround here
I'd like to be able to add a measure (the selected value from my TOP N slicer) as the value (instead of a hard-coded number) in the TOP N filter.
I'd like to be able to filter TOP N dynamically, taking a value from a slicer. The TOP N filter seems to accept only a hard-coded value.
Calvin Francart commented
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.
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.
Slicer that allows for top n e.g. 10, 50, 100 etc. and not at page filter.
Aswanth Rajeev commented
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.
Please add this. The others category should also be used to filter other visuals.
calculates the top N rows
allow to display top N row and collapse others under one row, with custom number N and custom field.
We really need this!