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.
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!
Solved! Go to 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?
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:
Can you try creating a DAX measure for "good %" and put it in the stacked column chart to use it as your sorting measure?
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |