Power BI

Completed

Top N Filters

Vote (1705)

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)

Josh Davis on 05 Jul 2020 22:33:04

RE: Top N Filters

Any update on this??? Waiting anxiously!

Ernest on 05 Jul 2020 22:33:03

RE: Top N Filters

Any update on this? Excel can do this in a flash #pivot

Andwu on 05 Jul 2020 22:32:32

RE: Top N Filters

We need an Other bucket as well. Is there already an ETA?

OD on 05 Jul 2020 22:32:32

RE: Top N Filters

Ronja, the piece of info you supplied worked for the Top N :-) Thank you!

Power BI User on 05 Jul 2020 22:32:18

RE: Top N Filters

When can we expect?

Kaare Daugaard Hansen on 05 Jul 2020 22:32:17

RE: Top N Filters

Great that you are working on this! I can't wait... :-)

I also would like the before mentioned idea of the "Other" bucket for the remaining values that are not included in the TOPN results.