Use a dynamical regrouping as a legend

Hi,

I've plotted into a stacked column chart the number of fishing methods ("method") used per month and year in a particular zone and village. Here is what it looks like right now:

Now, I'd like to show the top 3 most used methods together with a fourth method, "autre". The latter should regroup all the methods that are not top 3 under a single label.

I've managed to this by adding a static, calculated column in my table, which uses the RANKX function. Now I have an additional column ("method_aggregated") that is equal to "method" for the top 3 methods used, and is valued "autre" otherwise:

Now I'd like to dynamically determine what falls into the "autre" bin each time I change my filters, but I'm stuck. Any ideas on how I can do this? Workarounds are also welcome.

Here is what I've already tried:

• Determining the category (top 3 or "autre") through a measure and using the measure as a legend --> didn't work, as you can't use measures as a legend in Power BI.
• Creating a supporting table with all the possible filter combinations and their corresponding category labelling --> didn't work, as it's impossible to include all the possible date intervals.

Any help will be really appreciated!

Thanks,

Mansoor