Maintaining Custom Order in Power BI Stacked Column Chart's X-axis

I have a dataset in Power BI structured as:

When I create a stacked column chart, Power BI seems to sort the rango column in an unexpected order. For instance, 'b8-b6' appears right before 'b76-b74'. I would assume Power BI thinks b8 is larger than b76.
I attempted to maintain the order by adding a 'SortOrder' column, which assigns a unique number to each row based on my preferred order:

rangocountSortOrder

However, when I sort the visual by the SortOrder column, I lose the reference to the rango values on the X-axis.

My goal is to display the rango values on the X-axis, but in the specific order given by the 'SortOrder' column.

How can I achieve this?

This is my current output (notice how in the x axis, the ordering isn't the same as in the table):

And this is my expected output (i need this chart but instead of having the SortOrder in the x axis i need the rango coulmn):