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

    70d091b3 9cae-4662-b613-218d0d81dad6 on 05 Jul 2020 22:11:22

    RE: Top N Filters

    RANKX is seems to be useful if you're using a calculated column against an entire data set, but if I'm using a filter, for example, wanting to rank within a specific reason, I don't have a way to show TOP N within the scope of that filter.

    Power BI Ideas Admin's profile image Profile Picture

    7e80f62d 322a-4c52-b754-c3817dca87a0 on 05 Jul 2020 22:11:20

    RE: Top N Filters

    Be sure to bring this into BI Cloud as well!

    Power BI Ideas Admin's profile image Profile Picture

    278411ae bc91-e911-a965-000d3a4f33c1 on 05 Jul 2020 22:11:06

    RE: Top N Filters

    Have the ability to easily show only the top N rows in a visualization.
    Options : which measure to look at, define N number of rows, group all others in one single row.

    Power BI Ideas Admin's profile image Profile Picture

    bdc4ca7b 5ca3-4f53-a5c9-0c334858ca64 on 05 Jul 2020 22:10:59

    RE: Top N Filters

    This is easy to do with DAX...

    Power BI Ideas Admin's profile image Profile Picture

    1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:10:26

    RE: Top N Filters

    either top N or bottom N would be great.

    Power BI Ideas Admin's profile image Profile Picture

    cae85417 dac8-4a38-8b0e-d4cecb5be034 on 05 Jul 2020 22:09:33

    RE: Top N Filters

    Yes you can do this with Measure but would be nice if filter could just do it for you like in a Pivot Table in Excel.

    Power BI Ideas Admin's profile image Profile Picture

    24e77b92 b904-43b4-9b07-6c2c55afca03 on 05 Jul 2020 22:08:36

    RE: Top N Filters

    Agreed. Filtering by "TOP" with an "Order By" would be most helpful.

    Power BI Ideas Admin's profile image Profile Picture

    405e92d8 02d8-45c3-a3e7-bc1cd14a14d5 on 05 Jul 2020 22:06:09

    RE: Top N Filters

    Similar to the Excel Top 10 Feature which only shows the top 100/10/5 items from a table in the visualization.

    https://www.youtube.com/watch?v=KkfH2pvI84s

    Power BI Ideas Admin's profile image Profile Picture

    9c4e21b0 cb3d-4311-b6a5-0e2d998a47c2 on 05 Jul 2020 22:04:19

    RE: Top N Filters

    Do you like bypass? If yes you gonna use RANKX. Top N is a stright feature for report users for which reports are created.

    Power BI Ideas Admin's profile image Profile Picture

    e40cae72 caa2-e611-80f7-5065f38a4951 on 05 Jul 2020 22:03:54

    RE: Top N Filters

    Some calculated fields may help? See http://ayadshammout.com/2013/02/19/dax-rankx-function-scenarios/