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

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

    RE: Top n filter

    Add the option to filter By Top X%.
    for example: show the top 80% (Like in Excel pivot Table)

    Laura Collie's profile image Profile Picture

    f8d846da f0ce-490a-a0af-84ac69e28751 on 05 Jul 2020 23:22:17

    RE: Top n filter

    Hi everyone,

    I think it would be a great funcionality to have a visual-control/button/textbox with we can type the value of the n rows for top or button functionality in the table/matrix visuals. The idea is for give to user the posibility that he can define the value of n.

    Thanks for all!
    Bye

    Laura Collie's profile image Profile Picture

    d0aca558 5e84-498a-9cd8-6d63f1fe0aea on 05 Jul 2020 23:22:02

    RE: Top n filter

    I want to "Top N" on Page level filters and Report level filters.
    for filter all visuals on the page, on the report.

    Currently, I can filter "Top N" on Visual level filters.
    and, I use five or more visuals on the page,
    and, I need to filter each visual.

    So, I want to filter on Page / Report level filter.

    Laura Collie's profile image Profile Picture

    f2b6c943 c2dd-4dfd-ae17-fe5b45f136c2 on 05 Jul 2020 23:21:15

    RE: Top n filter

    Have a quick measure where there is an option to filter by Top N, example, Top 3 customers by sum of net sales

    Laura Collie's profile image Profile Picture

    f2b6c943 c2dd-4dfd-ae17-fe5b45f136c2 on 05 Jul 2020 23:21:12

    RE: Top n filter

    Have a quick measure where there is an option to filter by Top N, example, Top 3 customers by sum of net sales

    Laura Collie's profile image Profile Picture

    5f039ef1 843b-4763-89b7-a20f5646086d on 05 Jul 2020 23:20:02

    RE: Top n filter

    am lost.

    Laura Collie's profile image Profile Picture

    3cf78e08 1fea-4b06-8ffd-4844379fd57c on 05 Jul 2020 23:19:07

    RE: Top n filter

    having a hard time getting the top 5 products sold by state in DAX

    Laura Collie's profile image Profile Picture

    db161b29 07e9-48ec-946e-a24a2a02354c on 05 Jul 2020 23:18:18

    RE: Top n filter

    Allow top N filter within visualization to aggregate remaining balances to other automatically

    Laura Collie's profile image Profile Picture

    db161b29 07e9-48ec-946e-a24a2a02354c on 05 Jul 2020 23:18:18

    RE: Top n filter

    Allow top N filter within visualization to aggregate remaining balances to other automatically

    Laura Collie's profile image Profile Picture

    6dcd44f7 7121-4b01-b5b0-7ba38e3cd700 on 05 Jul 2020 23:18:07

    RE: Top n filter

    When using a Top N filter on a visual (ex. Pie Chart) it would be nice to "lock" the color palette so the chart would maintain the same look as items move in and out of the Top N.