Skip to main content

Power BI

Completed

Top N Filters

Vote (1705) Share
Power BI Ideas Admin's profile image

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)
Power BI Ideas Admin's profile image Profile Picture

Thiago Zavaschi on 05 Jul 2020 22:18:15

RE: Top N Filters

We need this ASAP. Qlik and other tools already have this easy way to filter data.

Power BI Ideas Admin's profile image Profile Picture

Binh Cao on 05 Jul 2020 22:18:15

RE: Top N Filters

also, do bottom N as well, or better yet, allow one to sort

Power BI Ideas Admin's profile image Profile Picture

Sasha Chizhova on 05 Jul 2020 22:18:14

RE: Top N Filters

You can do that with DAX so I don't thing that this is a high priority feature..

Power BI Ideas Admin's profile image Profile Picture

Lisa Wessells on 05 Jul 2020 22:17:58

RE: Top N Filters

Top % and Bottom % would also be helpful!

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:49

RE: Top N Filters

ABSOLUTELY POSITIVELY NEED Top N and 'Rest' as all others ASAP!!!! This is holding back full corporate adoption!!!!!!

Power BI Ideas Admin's profile image Profile Picture

DataSpinners on 05 Jul 2020 22:17:42

RE: Top N Filters

When will the status be changed to Planned? Based on the votes, i whould say its about time. Thanks!

Power BI Ideas Admin's profile image Profile Picture

Derek Venus on 05 Jul 2020 22:17:41

RE: Top N Filters

Just came up with this as a requirement in a report. It's a must have!!

Power BI Ideas Admin's profile image Profile Picture

Mark_Kimsey on 05 Jul 2020 22:17:40

RE: Top N Filters

I agree. Having a top 10, top 20, or even
a top "fill in the blank" would speed up report development. Thank you!

Power BI Ideas Admin's profile image Profile Picture

TK on 05 Jul 2020 22:17:22

RE: Top N Filters

Yes, TOP N filter is very useful

Power BI Ideas Admin's profile image Profile Picture

LAURENT SANCHEZ on 05 Jul 2020 22:17:21

RE: Top N Filters

Please add the TOP XX in PowerBI graphs !

Merged Idea (1)