Dynamic legend on bar chart doesn't sort categories properly when switching between selections

One of the fields was sorted by some other (index) column and worked fine, and the one working badly was sorted by itself only which apparently triggered some switch in there (so the sort everytime was by the value) . I changed the field so it's by default sorted by some other column from the table which caused so it doesnt switch to sorting by value everytime i change selection.