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

Mike on 05 Jul 2020 23:49:52

RE: Top N Filters

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/

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:55

RE: Top N Filters

calculates the top N rows

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:45

RE: Top N Filters

allow to display top N row and collapse others under one row, with custom number N and custom field.

Thanks

Power BI Ideas Admin's profile image Profile Picture

Vinicius on 05 Jul 2020 23:47:47

RE: Top N Filters

And the "Show Others" option?

Power BI Ideas Admin's profile image Profile Picture

Vinicius on 05 Jul 2020 23:47:47

RE: Top N Filters

We really need this!

Thanks

Power BI Ideas Admin's profile image Profile Picture

Vinicius on 05 Jul 2020 23:47:47

RE: Top N Filters

We really need this!
Thanks.

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:22

RE: Top N Filters

Create a group for Others that is not in the Top N

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:21

RE: Top N Filters

even i am looking for same future

Power BI Ideas Admin's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:21

RE: Top N Filters

In other Bi tolls like Tableau has this future , but in power bi we don't have yet

Power BI Ideas Admin's profile image Profile Picture

Chris Hudson on 05 Jul 2020 23:46:53

RE: Top N Filters

I've seen others as this but is there a plan to create a grouping for "others" outside of the top n #?

Merged Idea (1)