top n selection
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)
Roberta C commented
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.
Top N is there in the page level Filter you can choose that
to solve this for example https://kohera.be/nl/blog/business-intelligence-nl/power-bi-ranking-group/