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!

    Merged with Control over axes ranges
    Comments (163)
    Power BI Ideas Admin's profile image Profile Picture

    7ba09f30 5350-433c-a99e-e197f2b24660 on 05 Jul 2020 22:27:49

    RE: Top N Filters

    Please!!

    Power BI Ideas Admin's profile image Profile Picture

    974b1a3e fc60-420f-9090-c299ba4bed6a on 05 Jul 2020 22:27:48

    RE: Top N Filters

    Any updates on this one?

    Power BI Ideas Admin's profile image Profile Picture

    09916353 d32d-443f-9e6b-7869f9f8d879 on 05 Jul 2020 22:27:28

    RE: Top N Filters

    Do we have an ETA on this one?

    Power BI Ideas Admin's profile image Profile Picture

    37aa0500 95be-41b6-8696-aafb201fa760 on 05 Jul 2020 22:27:10

    RE: Top N Filters

    When can we have this, Its urgent. It's taking too much time.....

    Power BI Ideas Admin's profile image Profile Picture

    d07061b2 78ba-42c1-8c6f-5926f89f7555 on 05 Jul 2020 22:27:10

    RE: Top N Filters

    I need this feature! 3603 votes

    Power BI Ideas Admin's profile image Profile Picture

    9e5983c5 f031-41c5-892a-f4e4b37ab191 on 05 Jul 2020 22:27:09

    RE: Top N Filters

    I am waiting too... Its killing to create rank n rankx functions and confuse the clients and us as well...

    Power BI Ideas Admin's profile image Profile Picture

    66aebfb7 1041-4dff-9fe6-4464976afb3f on 05 Jul 2020 22:26:59

    RE: Top N Filters

    What's the progress on this? Is it close to being done?

    Power BI Ideas Admin's profile image Profile Picture

    687ff25b 69e2-43ea-ab9a-7d1efbc5b7bf on 05 Jul 2020 22:26:14

    RE: Top N Filters

    I want top 10 and remaining all together as 1, so now totally 11 rows . how can i do that.?

    Power BI Ideas Admin's profile image Profile Picture

    0c39f4f5 a952-4e72-ae32-cde595baf24d on 05 Jul 2020 22:26:10

    RE: Top N Filters

    awaited since LONG

    Power BI Ideas Admin's profile image Profile Picture

    c705ebae bb22-4684-9393-af598c59b3b5 on 05 Jul 2020 22:25:39

    RE: Top N Filters

    You can also solve this with an RANKX Function.
    E.G. if you want to identify your Top 10 Customers according to their Turnover just add two measures.

    Measure 1) Sum of Turnover = Sum(SalesFacts[Turnover])
    Measure 2) Rank = RANKX(ALL(Customer[Customer]),[Sum of Turnover])

    After that you just select the Measure Rank and the customers and set filters to