Forum Discussion
Top X with filter
I have a two charts displayed on my dashboard.
The first one displays a funnel for categories
The second one displays the top 10 items based on occurence.
When no category is selected, I want the overall top 10 items
But when a category is selected, I want the itemlist to be resorted to display the top 10 for that category.
Need a sample for doing this.
I have too done it with RANKX. Check out this article:
http://www.daxpatterns.com/parameter-table/
Scroll to the section called Limit Top N Elements in a Ranking for an example where the N is dynamic (but then you may set it to 10 internally).
3 Replies
While I do not currently have a sample available, I have successfully completed this by creating a RANKX based upon product performance and adding a filter to only show the top (or bottom) 25. As the slicers are selected the RANKX retains numerical order but filters out those that are not int he top performers.
You may also be able to use a version of TopN
I have too done it with RANKX. Check out this article:
http://www.daxpatterns.com/parameter-table/
Scroll to the section called Limit Top N Elements in a Ranking for an example where the N is dynamic (but then you may set it to 10 internally).
I like the pattern in this article.
Additionally, you can vote for native top n filters in Power BI here.
