How to sort a stacked column chart based on rank by total of what's in the 'Column Series'?

[Anonymous]

Hi all,

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: 

FamilyRank = Rankx(All(dimProgram[Family]), [Total FTEs], ,1)

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: 

I would appreciate any here here. Thank you!

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

I have answered in other similar posts, you can refer to

Data order in visualisation

Replace the clustered column chart with the stacked column chart

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This is incredible. Thank you.