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

    6e04e0ad 7bfe-4ba9-a2d3-97bf106a7474 on 06 Jul 2020 00:01:42

    RE: Top N Filters

    It's a great feature, being able to do TOP N, with N hard coded. Would it be possible to make N dynamic? I'd like to select N in a slicer (e.g. 5 or 10 or 20). There is a workaround using DAX (and RANKX), but as a newbie I'm finding this painful. More details at Avi Singh's video here:
    https://www.youtube.com/watch?v=wKfPS1yZfE0

    Thanks

    Power BI Ideas Admin's profile image Profile Picture

    4a20fda8 3896-41ab-b45f-0863a89477be on 05 Jul 2020 23:52:24

    RE: Top N Filters

    Please add TOPN with rest in Others

    Power BI Ideas Admin's profile image Profile Picture

    f9e5f484 9ed6-4b9e-ada6-260e70b526ea 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

    d367115e 0ab1-42dd-ac49-bef63dce9edc 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 #?

    Power BI Ideas Admin's profile image Profile Picture

    a5cc85c3 f316-436f-800d-d85ffa7ffa73 on 05 Jul 2020 23:38:46

    RE: Top N Filters

    Hi I'm not sure if i'm doing something wrong, but when I publish the report with a Top N filter on a viz. Each time I access the report it looses the filter. How do I make it so it keeps the filter once published?

    Power BI Ideas Admin's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:13:49

    RE: Top N Filters

    PLEASE PROVIDE TOP N VALUES FOR EACH PRODUCT BY GROPUING

    Power BI Ideas Admin's profile image Profile Picture

    041fa873 3c53-4081-bae9-868454199a11 on 05 Jul 2020 23:03:39

    RE: Top N Filters

    It would be nice if you add TOPN with rest in "Others".

    Power BI Ideas Admin's profile image Profile Picture

    f954aeb7 a36e-4c03-8e5c-515e1c1db0ae on 05 Jul 2020 22:54:28

    RE: Top N Filters

    'I’m not sure if this is the question already asked. But I'm trying to create a simple Table to give me:

    -For each "Brand"
    -Top X "Lines"
    -Based on Y "Measurement"

    Is this possible? I'm currently stuck on the part that I tell Power BI "For each "Brand" "

    Power BI Ideas Admin's profile image Profile Picture

    82126cc0 482e-4963-951a-934bb4cb3d8d on 05 Jul 2020 22:54:03

    RE: Top N Filters

    Hi, any plans about grouping the rest into an "Others" Group.

    Power BI Ideas Admin's profile image Profile Picture

    1a4e1465 942a-46b0-8d90-86073b58ecd9 on 05 Jul 2020 22:49:29

    RE: Top N Filters

    I think it is necessary to allow us to group the rest in other group