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

    7136188d 4c5d-4bb2-9623-267658e418a5 on 05 Jul 2020 23:35:03

    RE: Top n filter

    Is there a Top N Bottom N Quick Calculation that I am missing? Would be useful if it existed.

    Laura Collie's profile image Profile Picture

    93082dce 3d1b-4d7c-bc39-46bc31350fc9 on 05 Jul 2020 23:32:55

    RE: Top n filter

    Being able to filter for the top N% of a field would be immensely helpful. For example, the top 10% purchases are (or what items made up the top 10% of sales).

    Laura Collie's profile image Profile Picture

    e7dd35be 3102-49e5-8016-4827944729a4 on 05 Jul 2020 23:30:43

    RE: Top n filter

    It was the most challenge solutions I've had so far.
    Actually it is great idea.
    There is a work around that will work but is tough to grasp for in the beginning.
    https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi

    Laura Collie's profile image Profile Picture

    1681727c 38a4-416d-9940-f228178f3109 on 05 Jul 2020 23:29:36

    RE: Top n filter

    Top N filter is great, but it hides everything else, very often the distribution of data across categories has 80% in 2-5 categories and 20% spreadh across 20+ categories, can we choose a number N, then have PBI group the "other" categories based on any category below the top N?

    Laura Collie's profile image Profile Picture

    f9e5f484 9ed6-4b9e-ada6-260e70b526ea on 05 Jul 2020 23:27:24

    RE: Top n filter

    This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.

    Thanks.

    Laura Collie's profile image Profile Picture

    ef3d7858 ad19-41c2-aefd-406b92dbd05d on 05 Jul 2020 23:26:15

    RE: Top n filter

    Just started using PowerBI and could not believe this feature is not available. This is extremely important because most of the times it is necessary to understand what percentage of the total the top N correspond to. Please give us this feature.

    Laura Collie's profile image Profile Picture

    ef3d7858 ad19-41c2-aefd-406b92dbd05d on 05 Jul 2020 23:26:15

    RE: Top n filter

    Just started using PowerBI and could not believe this feature is not available. This is extremely important because most of the times it is necessary to understand what percentage of the total the top N correspond to. Please give us this feature.

    Laura Collie's profile image Profile Picture

    ef3d7858 ad19-41c2-aefd-406b92dbd05d on 05 Jul 2020 23:26:15

    RE: Top n filter

    Just started using PowerBI and could not believe this feature is not available, out-of-the-box. This is extremely important because most of the times it is necessary to understand what percentage of the total the top N correspond to. Please give us this feature.

    Laura Collie's profile image Profile Picture

    a3482e97 accf-49cb-a421-a36678f68cd3 on 05 Jul 2020 23:25:33

    RE: Top n filter

    I have been trying to create dynamic top n based on multiple columns, which have not worked for me so far. The visual level filters work but slicers do not work. It will be great to have this feature.

    Laura Collie's profile image Profile Picture

    4e25101c b385-4f55-83ac-88181dd28525 on 05 Jul 2020 23:24:42

    RE: Top n filter

    allow for filtering of top N values