How to sort a stacked column chart based on rank by total of what's in the 'Column Series'?
I'm having a bit of trouble here with something that seems like it would be so simple. I have a verticle stacked bar chart with the Month name in the 'Shared Axis', the Product Family Name in the 'column series' (which is what is being stacked), and the Total in the values.
Right now, it is showing an ugly Stacked Bar chart with a lot of the smaller values at the bottom of the chart, whereas the larger amounts are spread randomly in middle. How can I make a ranking of each of the Product family names based on the total per Product Family name? I don't know whether I should use a Measure or a Calculated column.
A calculated column seems like it'd be easier because I could 'Sort by" the rank if it's there, but I don't know how to do that. I've seen other people online make a measure like this, which is what I tried:
This measure would work on a simple table if I wanted to sort by it, but it does not work for a Stacked Column Chart. I'm not exactly sure where to go from here. Here is what the chart currently looks like: