Laura Collie on 22 Apr 2017 00:21:19
Top n Filter should be allowed on multiple fields and/or against multiple facts. For example - show top 10 sales people and lowest 10 products (both facts should be true to be displayed). As of April 2017, only one top n filter is allowed, so I'm exporting data to Excel for reporting.
Also, wish Excel could use my .pbix file as a data source for the PowerPivot data model - then i could easily work with any of the data (including all the measures). Power BI is a fantastic tool, but still needs Excel at times.
- Comments (99)
RE: Top n filter
It would be very helpful if Top N could also display an "Other" category so we could have an idea of the proportion of the data Top N represents and reconcile with the total shown on another visual.
RE: Top n filter
Adding a filter option that can, 'Show Items in Top N % of Value', e.g. 'Show Suppliers in Top 80% of Spend'.
This feature is currently available in Excel & adds immense versatility when analyzing large data-sets.
RE: Top n filter
It would be great along with Top N filter to have check box to keep Others as on option. Workaround now is adding column and Rank to achieve this.
Ex: If I want to show Top 10 Sales reps by Sale amount, it works but I have to show Others sales value with rest of sales reps. If we have as an check box, optionally can be used.
RE: Top n filter
Totally - I have pie charts that show everything with the top 10 broken out and other for all the rest and then I have a table that show what is in other. Every month I have to check all my custom groupings to see if the top 10 have changed and adjust them. I would love to have this dynamic. Also like to be able to see the same thing in a bar graph - the top x and then one for the other.
RE: Top n filter
This is definitely needed. When looking at the forums I find that people have simulated this functionality with complicated DAX formulas and measures but the existing Top N filters should just be able to accept a slicer value as the N value for the filter.
RE: Top n filter
Top N is there in the page level Filter you can choose that
RE: Top n filter
We need a slicer that can filter the top n customers by revenue in a page. The option to use a top n page level filter is unavailable.
RE: Top n filter
TopN plus Other, for all visuals, like is available in the New Waterfall update, which is phenomenal, awesome....
RE: Top n filter
When you select the TOP N, add the remaining items summarized in "Other" to have the total reconciled.
RE: Top n filter
It would be great to have a top N slicer. same as available in the visuals filters. But as a slicer in the dashboard. Sometimes you want to slice a particular chart or series of charts by top 5 clients/ products etc, and the users are not aware of the fact that they need to open the right filters pane for that.