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

    Michiel Schepers on 05 Jul 2020 23:38:19

    RE: Top N Filters

    Yes fully agree, PBI please add this feature to the Top N filter! This will allow users to create readable charts while still keeping totals the same.

    Power BI Ideas Admin's profile image Profile Picture

    Michiel Schepers on 05 Jul 2020 23:38:19

    RE: Top N Filters

    Yes this feature would be much appreciated! Similar to the Idea "Other" group in top N filter".
    For me personally, just extending the Top N filter feature with the option to aggregate the rest as "other" would suffice and seems to be low effort to develop.

    Power BI Ideas Admin's profile image Profile Picture

    Vinicius on 05 Jul 2020 23:36:36

    RE: Top N Filters



    This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.

    Thanks.

    There´s other 3 ideas like this one.

    Power BI Ideas Admin's profile image Profile Picture

    Vinicius on 05 Jul 2020 23:36:36

    RE: Top N Filters

    Any advance on this feature?

    Power BI Ideas Admin's profile image Profile Picture

    Vinicius on 05 Jul 2020 23:36:36

    RE: Top N Filters



    This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.

    Thanks.

    Power BI Ideas Admin's profile image Profile Picture

    Raja on 05 Jul 2020 23:36:27

    RE: Top N Filters

    Can you please add Top and Bottom N under the Filter Type for Visual level filters. This helps to see Top and Bottom N in one chart or grid?

    Power BI Ideas Admin's profile image Profile Picture

    Arpit Ohri on 05 Jul 2020 23:36:22

    RE: Top N Filters

    Currently, the number of bars or columns in bar or column charts displayed depends on the number of distinct values in the field used in the axis. We should have the option to display only top n and remaining should be grouped as others.

    Power BI Ideas Admin's profile image Profile Picture

    Heath on 05 Jul 2020 23:35:03

    RE: Top N Filters

    Is there a Top N Bottom N Quick Calculation that I am missing? Would be useful if it existed.

    Power BI Ideas Admin's profile image Profile Picture

    Jennifer Holton on 05 Jul 2020 23:32:55

    RE: Top N Filters

    Being able to filter for the top N% of a field would be immensely helpful. For example, the top 10% purchases are (or what items made up the top 10% of sales).

    Power BI Ideas Admin's profile image Profile Picture

    Joao on 05 Jul 2020 23:30:43

    RE: Top N Filters

    It was the most challenge solutions I've had so far.
    Actually it is great idea.
    There is a work around that will work but is tough to grasp for in the beginning.
    https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi

    Merged Idea (1)