Power BI

Needs Votes

Top n filter

Vote (503)

Laura Collie on 22 Apr 2017 00:21:19

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.

Comments (99)

Comments (99)

6e04e0ad 7bfe-4ba9-a2d3-97bf106a7474 on 06 Jul 2020 00:01:40

RE: Top n filter

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.

6e04e0ad 7bfe-4ba9-a2d3-97bf106a7474 on 06 Jul 2020 00:01:40

RE: Top n filter

Avi Singh shows a workaround here
https://www.youtube.com/watch?v=wKfPS1yZfE0

1e4d6b96 ba92-4bee-bcab-9e6de4ea02cc on 06 Jul 2020 00:00:06

RE: Top n filter

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.

7005196c e749-4dce-a334-2faba77b9006 on 05 Jul 2020 23:58:25

RE: Top n filter

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.

0c129281 bfa8-4de8-88e3-df742dbf7b47 on 05 Jul 2020 23:56:30

RE: Top n filter

Slicer that allows for top n e.g. 10, 50, 100 etc. and not at page filter.

d1d14b1b c025-4453-8bba-2553ef51cde5 on 05 Jul 2020 23:51:43

RE: Top n filter

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.

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 23:49:52

RE: Top n filter

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/