Sort stacked column chart based on a rank value

[Anonymous]

Hello ,

i have the report that show me the top 3  of my products + Others   like as bellow : 

I have a measure that show me the rank, of my product and i want to display the stacked bar based on my Rank value , for example for the date 7/11/2022 , the product in yellow was sold more than Orange the result that i want for date 7/11/2022 Bleu-Yellow then Orange .
The rank value give me the right result but i didn't see on the chart how can i filter by the rank .

I tried the tooltip for sorting but didn't work .

I joined a pbix to have an idea about my measure.

Link for the pbix

Any help to fix that ? 
Thanks 

[Ahmedx]

try Throw in your [Rank] in Y-axis and throw in [Top N SUM] in a tooltip

[amitchandak]

@Anonymous , Based on what I got so far, check if this can help

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

[Anonymous]

Hi @amitchandak 

I don't have any problem with top N+others but the problem that I have is sorting the stucked bar based on rank value