Sorting Stack Bar by one of the stacked level

Hey All,
This is a stacked chart by category
The values inside of category are A,B,C.


Here I want to sort the Y axis by the category A
The name with the highest percent for A at the top and name with the lowest percent for category A at the bottom.

Is that possible???


I actually don’t think that’s possible without a trick. The order by y-as function does not offer this as a function. But what you could do is create a custom calculated field, that calculates the percentage of A in this column, and use that calculated field to order by in the y-as. A bit of hassle, but if it’s important in your visualisation. That will do the trick.

Hope this helps!