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

    a9fde69c 6da0-489b-a3b0-b1a6b6e7c987 on 05 Jul 2020 22:19:36

    RE: Top N Filters

    this would be great to have

    Power BI Ideas Admin's profile image Profile Picture

    a66e1bfa 8c23-4642-b511-a4613893c263 on 05 Jul 2020 22:19:17

    RE: Top N Filters

    how to get value entered in date filters?

    Power BI Ideas Admin's profile image Profile Picture

    48253d7f 98f8-485e-ba10-e6a9ef313689 on 05 Jul 2020 22:19:15

    RE: Top N Filters

    I also want to use the Top N Filtering. I have a data column which varies daily/weekly. And I want my report to show only top 5 rows (in count). I cannot do manual filtering every time the data varies.
    Can anyone help?
    Please reach me at muhammad.hassan@techlogix.com

    Power BI Ideas Admin's profile image Profile Picture

    f5d30fc9 636b-4974-83e7-5c05b46919c6 on 05 Jul 2020 22:19:02

    RE: Top N Filters

    NOW.

    Power BI Ideas Admin's profile image Profile Picture

    345ba763 be8a-49e0-8881-c9b46fc21f68 on 05 Jul 2020 22:19:02

    RE: Top N Filters

    I would like to limit or filter graphs to show the top 10 customers, for example, or the bottom 10.

    Power BI Ideas Admin's profile image Profile Picture

    24d1dacc 3327-408d-a4f2-a576791414af on 05 Jul 2020 22:18:59

    RE: Top N Filters

    This is basic for Self BI. As a BI developer, I can create a metric. But for a business client that doesn't anything, this is basic.

    Power BI Ideas Admin's profile image Profile Picture

    0e6a0605 bea8-4f9f-88a3-1a4d344d68cb on 05 Jul 2020 22:18:56

    RE: Top N Filters

    CRITICAL!

    Power BI Ideas Admin's profile image Profile Picture

    ee6b0cd7 0e08-4980-80e8-98910473f04c on 05 Jul 2020 22:18:52

    RE: Top N Filters

    Why no update from PowerBI team?

    Power BI Ideas Admin's profile image Profile Picture

    c15050fb 91c7-4393-a41d-c85935f38492 on 05 Jul 2020 22:18:26

    RE: Top N Filters

    As all my fellow posters, I agree... we need this very much. This is crucial when making meaningful reports

    Power BI Ideas Admin's profile image Profile Picture

    4e2ed990 e62a-4956-94cf-e2ae7078a9e9 on 05 Jul 2020 22:18:24

    RE: Top N Filters

    This is a really important feature that is missing that will make all sorts of things easier to do. Not only will it be useful for looking at tables of the top x things but it will also should allow an easy way to show the latest data as top 1 of dates should show the latest data point without having to worry about a DAX measure for this.