How to SORT STACKS WITHIN each column of a stacked column chart?

[Anonymous]

This is a TWO part question: 

1) I'm trying to get the image on the left to be like the image on the right - where each segment in the column is truly stacked AND SORTED by measure specific to each column (in this case candidate).   

2) Also just to accomplish the image on the left I used the sort by column function in Power BI as required but I had to create a new aggregate table for this as there were multiple records with the votes for each county.  See 2nd image below.  Is this really the best way to accomplish this sort?

I can attach the Desktop workbook but I still haven't figured out how to do that.

[mahoneypat · Accepted solution]

You can use a ribbon chart to see the sort in opposite order (biggest at top).  If needed, you can set transparency of the ribbon to 100 to hide them.

Regards,

Pat

[Anonymous]

Awesome!

[AlB]

Hi @Anonymous 

You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

I uploaded the Desktop workbook here:

http://s000.tinyupload.com/?file_id=25819765647999179765