Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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