Skip to main content

Power BI

Merged

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 14 Apr 2021 09:53:26

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

9d081dd6 851c-41ca-9931-5f9d1fe91ea9 on 05 Jul 2020 22:16:29

RE: Top N Filters

We really, really, really need this. Excel like filtering on Tables, Charts, etc. is very important to end users, wrtining DAX will not work for end users. I want to just show Top N based on criteria, just like Excel, very easy for end users to do.

Power BI Ideas Admin's profile image Profile Picture

21cf1f63 5b03-4080-af6b-4701d6d1c3c4 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

8b624ee5 d64d-426c-b935-7d21cd0fbd2d 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

5a694ba2 de1a-407f-a36e-64acdfd498f8 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

d52745b3 2489-4656-b660-bff337128c09 on 05 Jul 2020 22:15:52

RE: Top N Filters

Any comment? Schedule?

Power BI Ideas Admin's profile image Profile Picture

ef7cf2a1 603f-4084-a88e-1e12b14d187e 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

4f0999e8 41bd-4901-8ff6-94005adb2ebb 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

1f7f2711 5819-e611-80e2-c4346bad91c4 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

ffed40a6 8617-4ab7-ad74-b4c64c34c175 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

ebf20ac9 1f45-49f7-916f-d4089b6a04b2 on 05 Jul 2020 22:14:50

RE: Top N Filters

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