Hello,
I'm trying to sort a Stacked Column Chart using a sort order table for the legend. I followed the steps by selecting Column Tools and setting the Sort Order column. However, it sorts by the data within the y-axis instead. I would like the legend to be sorted as: Gold, Silver, Bronze.
Please see attached example.
Could you please advise what I'm missing?
Many thanks.
Hi Danielle,
I wasn't able to download the Power BI file for some reason, but it'll be because you haven't set the Sort By for the Medals. See lesson 3.04.
Let me know if you're still having trouble.
Mynda
Thanks, Mynda.
I followed the instructions from Lesson 3.04. But it still doesn't sort using the Sort Order. It appears to be sorting alphabetically. I can't figure out what I'm missing.
I've re-run the pbix file hoping you might be able to open and please have a look? I've tried to attach screenshots but it will not allow me to attach powerpoint files.
EDIT: I watched the lesson many times, and just figured out that I was highlighting the "Order" column in the table when I selected sort order, when I should have highlighted the "Medals" column. Missed a small but key detail. Happy I found it now.
Awesome to hear! You won't miss that again
