How can we improve Power BI?

Top N Filters

Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'

1,715 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

161 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Chris commented  ·   ·  Flag as inappropriate

    I've seen others as this but is there a plan to create a grouping for "others" outside of the top n #?

  • Adam Buckley commented  ·   ·  Flag as inappropriate

    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?

  • Yasiel M. commented  ·   ·  Flag as inappropriate

    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" "

  • Marcelo Navarro commented  ·   ·  Flag as inappropriate

    Great feature, but do you want to make it perfect? Allow us to group the non top N records into an "other" group. Then the Total would be displayed correctly and we would be able to see the size of the non top N. SAP's B.O. has this functionality.

  • Katrina commented  ·   ·  Flag as inappropriate

    Hello, I was excited to see a Search function for the slicer. However, for some reason when I add in my criteria (in my case "Case Number") I then go to the ... to initiate "Search" and there is no option there. Only "Sort By Case Number", "Export Data" and "Remove"

    I've updated to the newest Power BI.
    What am I missing?

    Please Advise.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi Will,
    very pleased to see having an update on this. That'll help us a lot with designing reports.
    Could you, within the next releases publish an extension to this feature, that you have a TopN per category filter?
    Like I have 3 categories and want for each the top 5 sales, I would need to have 3x5 = 15 items in my table

  • Marcos Fontes commented  ·   ·  Flag as inappropriate

    I identified a problem in the filter behavior "TOP N" when the report already has other filters. For example, I want to show the 10 players with the best performance, but had a filter for matches > 5. When you apply the "TOP 10" filter, are returned only 3 players, because the filter "TOP N" filters the original data, and not the data already filtered by the "greater than 5 matches." I believe the correct behavior would be the filter "TOP N" respect other filters applied. That is, the TOP N should be the last filter applied, not the first.

  • Cristian commented  ·   ·  Flag as inappropriate

    excellent, thank you, if you could include the option to show the rest of the data as a row "other" would be great.

← Previous 1 3 4 5 8 9

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.