Skip to main content
Microsoft Idea

    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)