Skip to main content

    Power BI

    Needs Votes

    Top n filter

    Vote (503) Share
    Laura Collie's profile image

    Laura Collie on 22 Apr 2017 00:21:19

    Top n Filter should be allowed on multiple fields and/or against multiple facts. For example - show top 10 sales people and lowest 10 products (both facts should be true to be displayed). As of April 2017, only one top n filter is allowed, so I'm exporting data to Excel for reporting.

    Also, wish Excel could use my .pbix file as a data source for the PowerPivot data model - then i could easily work with any of the data (including all the measures). Power BI is a fantastic tool, but still needs Excel at times.

    Comments (99)
    Laura Collie's profile image Profile Picture

    a0c7e2d5 20e9-4259-a557-1051cc9557c6 on 06 Jul 2020 00:13:48

    RE: Top n filter

    Hi,

    When using "Top N" feature on visuals, please make it possible to add "Other".

    So selecting "Top N" based on Sales, it would be possible to select "Group rest as Other".

    I can there are several workarounds with ranks, but I don't find it very dynamic with slicers etc. This would be gamechanger!

    Laura Collie's profile image Profile Picture

    100668d8 fd02-40d0-b00c-6685ee6f9391 on 06 Jul 2020 00:12:44

    RE: Top n filter

    Editing dataflows can be quite painful. What would help would be if information about them - and processing steps - could be saved along with the dataflow, so that when opening one to edit, rather than having to wait for processing to finish, it opened with sample data immediately.

    Laura Collie's profile image Profile Picture

    a3c34312 353f-47b3-9c0f-3c44d0fcbb85 on 06 Jul 2020 00:10:02

    RE: Top n filter

    also page level filter

    Laura Collie's profile image Profile Picture

    80b67b23 a076-4e2c-8c83-51c1f1afb43b on 06 Jul 2020 00:08:26

    RE: Top n filter

    It will be nice to have option to suppress middle values in table. In summary we will have: top N records, suppressed "line" that can be expanded (show all records), bottom N records. Thanks!

    Laura Collie's profile image Profile Picture

    dc3cd819 8e57-46c4-bb2d-27c23ac95172 on 06 Jul 2020 00:07:31

    RE: Top n filter

    Such a shame it was not implemented with TopN feature. Development team does not have any clue about analytics and charting?

    Laura Collie's profile image Profile Picture

    799a2f7d 62bc-41e6-b24f-e5ca45a3b3b6 on 06 Jul 2020 00:06:29

    RE: Top n filter

    To allow top N on each visual, being able to select the measure from which the Top N will filter the data.

    Link with image as below:

    https://community.powerbi.com/t5/Report-Server/Idea-for-visual-Top-N-on-visual-Typing-here-as-no-images-can-be/m-p/905694#M12718

    Laura Collie's profile image Profile Picture

    fdd6c11b e8db-45fa-8fca-2553bb19b3e5 on 06 Jul 2020 00:06:16

    RE: Top n filter

    Actually it is not possible to use a WhatIf parameter for a TopN filter.
    This mean that the user is not able to dynamically set the amount of rows in the Visual filtered by a TopN.

    This should not be a big deal to add this feature.

    Thank you
    Regards
    Salvatore

    Laura Collie's profile image Profile Picture

    20ce64f2 8fd3-467e-b7b0-8ce8dbd70848 on 06 Jul 2020 00:05:35

    RE: Top n filter

    Please, we need this

    Laura Collie's profile image Profile Picture

    2d1c49ba e23c-4842-969a-95e47042abbd on 06 Jul 2020 00:05:21

    RE: Top n filter

    Can we have top / bottom N filter just above the visual in the report page for easy navigation for selection of Top / Bottom N filter. This feature is available in Tableau so that people migrating from Tableau to Power BI should have the same experience instead of selecting the visual and navigating to the right filter section for applying filter. Thanks in advance.

    Laura Collie's profile image Profile Picture

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

    RE: Top n filter

    I'd like to be able to filter TOP N dynamically, taking a value from a slicer. The TOP N filter seems to accept only a hard-coded value.