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 10 Jul 2020 16:04:36
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!
- Comments (264)
- Merged Idea (1)
RE: Top N Filters
Currently, I can only show top n values in any table/graph if I create a measure using DAX. It could be really nice if it was possible to have a "show top n values" in the filter selection pane.
RE: Top N Filters
Hello,
Please add Page and Visual level filter by Value.
In the same way as you did it for top n.
RE: Top N Filters
Really desirable
RE: Top N Filters
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.
RE: Top N Filters
Add ability to have slicer use top n rows
RE: Top N Filters
'I have been using Top N feature on Power BI ever since it was released however, I realised today that it does not work well if applied along with other measure filter on the same grid. Basically, the Top N function is applied before any other filter hence there are cases when this returns less than N rows. Here is how you reproduce:
- Take a matrix visualization. Put couple of fields on rows and few measures in values.
- Take any column that is on row and apply top N filter for any measure you desire.
- Now take another measure that is visible and apply an advance filter where value > 100 or value is < 0 etc.
- What you will notice is the top N filter is applied first and then the second filter whereas it should filter the second one first and then applying top N filter.
Make sense?
RE: Top N Filters
I would love a new "dynamic" grouping capability that would display a Categorical Column showing the Top n values and then all the other grouped as "Other": I would select the field to group, the formula to calculate (Count, Sum etc.) the ranking and the threshold (i.e. Top n, % of Total or absolute value) (this is similar to the Top n Filtering capability, but it keeps ALL data in the Totals etc.) (Note: the Sundance Visual automatically creates such Other category, but without a sort capability)
Rationale:
Quite often there is a long list of items where only a small number account for 80% of the variable to explain (i.e. 20% of Products account for 80% of Sales) . I find it quite difficult to generate any report where the top 20% products would appear by name and all the other would be grouped as 'Other':
• The new Group feature requires that I create (manually) a separate group for EACH of the 20% top products, then an "Other" group for the 80% remaining and it still displays each product in some reports.
• I can generate a new Table with the Summarize and Filter Functions that would contain only the Top 20 product names by Sales and link it (with a one to many relation) to the main Table: however, when I report, the "other" products appear as a blank line.
• In fact, I need to create a new Table with two columns: the original Product name, and the "Grouped Product" one which takes the value of the product name for the Top 20 and the value 'Other' for the remainder of the list (this involves several steps , usually include the RANKX function etc.). Then I have to relate it to the data Table. And even then there are issues such as 'blank' values etc.
Note: since all this is mostly for reporting purposes, this could be implemented initially in a Filter Visual or in the Table or Matrix Visual by modifying the Top N filtering capability
RE: Top N Filters
For create a table of the stores with more seals, or the products liked for the people.
RE: Top N Filters
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.
RE: Top N Filters
I love the top n feature. Are there any plans to show the top %?