Sorting both legend and x axis

Hi,

I created a colored stacked bar graph.

Color showing customer satisfaction level: Very low to very high

X axis showing the countries (my company has a specific order to list the countries)

I wish to custom sort both the legend variables and the x axis at the same time.

I can create custom sort order for both separately, but i can't activate both sorting at the same time.

Every time when I choose one of them, the other will revert back to alphabetic sorting.

I can do this in other dashboard platforms so I'm puzzled as why I could not do it here.

Could someone please advise?