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
Have a quick measure where there is an option to filter by Top N, example, Top 3 customers by sum of net sales
RE: Top N Filters
Have a quick measure where there is an option to filter by Top N, example, Top 3 customers by sum of net sales
RE: Top N Filters
am lost.
RE: Top N Filters
having a hard time getting the top 5 products sold by state in DAX
RE: Top N Filters
Allow top N filter within visualization to aggregate remaining balances to other automatically
RE: Top N Filters
Allow top N filter within visualization to aggregate remaining balances to other automatically
RE: Top N Filters
When using a Top N filter on a visual (ex. Pie Chart) it would be nice to "lock" the color palette so the chart would maintain the same look as items move in and out of the Top N.
RE: Top N Filters
While your looking at top n please add a include rest of data as "others" option in the TOP n filter
RE: Top N Filters
When using the Top/Bottom filter for a visual, allow the ability to group remaining items into All Other. For example if Top 10 is selected, remaining items ranked 11+ are grouped into an All Other category that the user can label.
RE: Top N Filters
It would be great if the Top N functionality allowed you to optionally group remaining items into another category that could be labeled by the user e.g., All Other. This would give a better perspective of the Top N.