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 great to take this a bit farther:
- Show the top/bottom n as individual members and group all other
- Show the top x % as individual members and group all others
- Show individuals until the other group is less than the largest individual member
- Group by % (top 2%, next 18%, remaining...)
RE: Top n filter
to solve this for example https://kohera.be/nl/blog/business-intelligence-nl/power-bi-ranking-group/
RE: Top n filter
If I select a top 5 for example, I want also see the Total amounts for the other products. If possible I want this dynamic. So in my table I see the top 5 and “others” with the amount that is left ( Total amount - top 5 amount)
RE: Top n filter
Please add Top N filter support for both page level filters and slicers.
RE: Top n filter
Top N filter is available as a visual level filter, but not as a report level filter. It would be much simpler to automatically filter an entire report to the current month by added a Top N filter to the report level filters.
RE: Top n filter
Please provide a option to select top / bottom N values in bar charts based on the dimensions.
RE: Top n filter
Top N Slicers
Create a Slicers that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
Similar to "Top N Filters". But we need this option in the Report visual for some of our customers.
RE: Top n filter
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 filter
Hello,
Please add Page and Visual level filter by Value.
In the same way as you did it for top n.
RE: Top n filter
Really desirable