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.
