How do I sort a stacked column chart sort by another column

[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 

[amitchandak]

@Anonymous , Make sure you have separate product and Date Dimensions/Table, and then Try like

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