Categories in reverse order for stacked bar chart 2 axis

[rikkyshh]

Hello

Not sure why, but does anyone know how to resolve the issue on the attached image

I have a stacked bar chart, one attribute is on 2nd axis as its the sum of the others to show the absolute change.

When I select categories in reverse order only the attributes on the 1st axis change, those on the 2nd axis do not.

[rorya]

You may need to show the second X axis, apply that setting there too, then you can hide it again.

[rikkyshh]

I want to sort the retailer by reverse order, as its extracted from software in a particular order and for some reason with stacked bar charts it draws it in reverse order.
When I do this, measures 1 to 4 (primary axis) are correct, but the total change black bar on the secondary axis doesnt swap.

I tried the above, alignning the two axis so that it crosses 0 but it just screws it up

attached is an example

[rikkyshh]

Sorry got it now, thank you!!