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
In a grid, I want to display the grand total ignoring the TOP N setup in the grid.
like my top 20 customers, but the grand total I want all the customers, not only the total of the top 20
RE: Top N Filters
I want to be able to filter the entire report (and page) by the Top 4 months by earliest date instead of only being to filter top N months at a visual level.
RE: Top N Filters
You should look at using a helper GENERATESERIES () table with an additional column for grouping the "other" category.
RE: Top N Filters
Allow User to rank TOP N items plus dynamically create Other group for all the other items.
For example bar chart visual ranks the Top 5 items by category with sum(count or percentage) but also includes a 6th grouping for all the other items which don't fall into the TOP 5. This 'other' category displays the value (count, sum, %, ...) which will give insight into how ALL the 'Other' items compare to the TOP 5.
RE: Top N Filters
Currently we can filter by "Top N", but what if you want just the data at the second or third ranked attribute?
You need to create a RANKX measure to get a rank that can be modified by slicers. However, this measure cannot be used as a filter for other data. A RANKX calculated column cannot be modified by slicers, but can be used to filter...
This might be able to be done though some complex DAX, but it would be useful to have "Filter by rank" alongside "Top N".
RE: Top N Filters
TOP N and BOTTOM N are always useful for analysing data, so it would be necessary to add those 2 functions to Quick measures
RE: Top N Filters
The workaround mentioned above also only provides you a static ability to do this, which can yield unintuitive results when using filters on the graphs. This functionality has been requested multiple times by our users and each time we bashfully cannot provide them the simple functionality and analytics that so much of Power BI provides.
RE: Top N Filters
rather surprised this was not part of initial build of TopN feature. This is basic functionality that is expected to be here. Many competing products simply have a check box to "include Others" as a category.
RE: Top N Filters
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?
RE: Top N Filters
Add an intuitive user interface within the chart value filters to show the top/bottom X values.