Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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).
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
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |