Data Values Order in Stacked Bar Chart

In creating a stacked bar chart to plot survey responses to a Likert scale question, I've been able to create a 'sort order' table which fixes the issue of sorting the Legend into the correct order, but that isn't translating to the Values and the percent who responded 'Disagree' is being displayed as more negative than 'Strongly Disagree' in the bars (see image below)

I've tried changing the 'Sort By' options in the fly-out menu of the visual, I've tried referencing the value from both the 'sort order' table I created to sort the legend as well as from the original 'survey responses' table, and I've tried tricking it alphabetically by adding a space or the number 1 to the front of the Strongly Disagree option, and in all instances the value bars will display the Disagree responses to the left of the Strongly Disagree responses.

There has to be a simple fix to this and the fact I haven't been able to figure it out yet is driving me mad, so any suggestions is greatly appreciated -- thank you!