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
We really need this!
Thanks.
RE: Top n filter
Create a group for Others that is not in the Top N
RE: Top n filter
even i am looking for same future
RE: Top n filter
In other Bi tolls like Tableau has this future , but in power bi we don't have yet
RE: Top n filter
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 filter
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 filter
You should look at using a helper GENERATESERIES () table with an additional column for grouping the "other" category.
RE: Top n filter
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 filter
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 filter
TOP N and BOTTOM N are always useful for analysing data, so it would be necessary to add those 2 functions to Quick measures