Dynamic sort of items in stacked chart

[A_Miller]

Good morning,

I am new to Power BI, but have some experience with PowerPivot use. I have been searching the forum for an answer and I am not sure if I am looking for the right questions, but here is my problem.

I work in a tire manufacturing facility that assigns a barcode to every tire produced. When a tire is scrapped, we have a list of all the production details as well as the scrap reason in terms of a three digit code (ie, 41, 112, 60, etc).

I have created a stacked column chart, but I would like to sort this chart, dynamically, based on the count of values for each code. When I put this in a table, I can sort, but when I move it back to a chart the X-Axis goes back to numerically. My chart has reason codes on the X-Axis and the count of distinct barcodes for the Y-Axis.

Can someone help point me to an article or a solution that will change the sorting? I am trying RankX, but am struggling to get the ordering column to work properly.

Thanks.

[stretcharm · Accepted solution]

Not used this myself but here are examples of changing chart axis dynamically

http://tinylizard.com/dynamically-changing-chart-axis/

https://www.youtube.com/watch?v=n-OWNaCUU0o