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
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?
RE: Top N Filters
This feature is really important. The workaround isn´t usefull because we can´t sort other´s at the end of the list.
Thanks.
RE: Top N Filters
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.
RE: Top N Filters
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.
RE: Top N Filters
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.
RE: Top N Filters
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.
RE: Top N Filters
allow for filtering of top N values
RE: Top N Filters
Add the option to filter By Top X%.
for example: show the top 80% (Like in Excel pivot Table)
RE: Top N Filters
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
RE: Top N Filters
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.