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

Power BI User on 05 Jul 2020 22:16:21

RE: Top N Filters

Yes please - users often want to view more detail

Power BI Ideas Admin's profile image Profile Picture

Ritam Pal on 05 Jul 2020 22:16:16

RE: Top N Filters

Should add a Top N filter system for better dashboard viewing. A simple Rank function can be used. This is a very important tool needed for Dashboard analysis on a large dataset.

Power BI Ideas Admin's profile image Profile Picture

Keith Suckling on 05 Jul 2020 22:16:15

RE: Top N Filters

This is actually the same idea as this one, except the broader input fields have more uses.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9414921-input-fields

Power BI Ideas Admin's profile image Profile Picture

Omar on 05 Jul 2020 22:15:52

RE: Top N Filters

Any comment? Schedule?

Power BI Ideas Admin's profile image Profile Picture

Vnay on 05 Jul 2020 22:15:47

RE: Top N Filters

This feature is absolutely necessary to make the product at par with the current bunch of competitor products. Any timeline for this one please?

Power BI Ideas Admin's profile image Profile Picture

Tristan on 05 Jul 2020 22:15:39

RE: Top N Filters

Any update or plan to release?

Power BI Ideas Admin's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:15:28

RE: Top N Filters

Yep, at the moment this can be done with DAX formulas. But you gotta admit that having this feature under filtering makes total sense for the end-users.

Power BI Ideas Admin's profile image Profile Picture

Jon on 05 Jul 2020 22:14:55

RE: Top N Filters

Still no update on this??????

Power BI Ideas Admin's profile image Profile Picture

Paula on 05 Jul 2020 22:14:50

RE: Top N Filters

This would be very helpful, if not even a must.

Power BI Ideas Admin's profile image Profile Picture

Adi on 05 Jul 2020 22:14:49

RE: Top N Filters

why it is not even in the default filter?

Merged Idea (1)