Sort Y-axis on stacked bar chart with small multiples

[skanord]

Hello, 

I have this visual:

And i would like to sort the values in the visual from largest to smallest. When i click on the three dots i get the following options for sorting:

 

The "sort small multiples" only sort the order of the small, so it moves the column. As far as i can see i can only sort the Y-axis alphabetically. Is there anything I am missing? This feature doesn't make much sense to me, if you can't display your data asc or desc... 

My values come from measures. My inputs are strucktured like this:

Any help is appreciated. 

[amitchandak]

@skanord , As there is the common axis between visual, sorting value as the visual level is not available

[skanord · Accepted solution]

I solved it by getting the visual: 

Stacked Bar Chart by Akvelon

[skanord]

Is there a workaround? Or is there another visual that can manage this?