100% stacked bar/column chart - sort by percentage

[Lorenski]

I know this has been posted several times, and I've tried numerous Google searches.  But am still failing to get the result I desire.

Like many others, I need a 100% stacked bar/column chart to be sorted by the good percentage.  I have a bunch of work centers (machines) that are being monitored.  On one graph, I have the count of good vs scrap parts.  Then on another graph, I have the percentage of good vs scrap.  I want to sort by work center/machine with the highest percentage of good parts.  So far, I've been unable to accomplish this.

Here's my current percentage chart:

 Here is the current count chart (This is what I want the percentage chart to look like! Highest percentage of good/green at the left):

And here is my data table this is coming from (I added the % column myself, when I was reading other threads/videos & trying to make this sort correctly):

Thank you in advance for any help!

[Lorenski]

@otravers 

Thank you!  I had a feeling it would be something simple by the time I got to posting here 😄

So, to recap for other readers: in my original post, I was trying to use a calculated column and not a DAX measure.  After @otravers reply, I had to brush up on calculated column vs measure.  Once I came up with the right measure, then put that into the Tooltips, then sorted by in the upper right of the chart, I got what I needed:

[otravers · Accepted solution]

Can you try creating a DAX measure for "good %" and put it in the stacked column chart to use it as your sorting measure?