How to create dynamic ranking for top 10 + others

[dgilm33]

Hi,

I'm trying to create a top 10 + Other ranking that, in my example data below, would show the top 10 vendors + other by spend in the donut chart. I have been able to get close to acheving this. However, my biggest problem comes with the detail table. I would like the ability to click the "Other" donut slice and the detail table filter to those vendors that make up that "Other" spend. To this point when I try and create this, I click the "Other" slice, and the detail spend numbers are blank. Is this possible?

Thank you for any help!

[Ritaf1983]

Hi @dgilm33 

Please refer to the linked tutorial :

https://www.youtube.com/watch?v=UAnylK9bm1I&t=191s

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

[dgilm33]

Hi Ritaf1983,

I tried using this, along with other possible solutions, however it doesn't appear to be possible at this time with Power BI. Thank you for your response though!