By default the 100% stacked bar chart is sorted by the actual value. But that’s not very useful as its hard to see what is the top category by %. Fortunately you can achieve the sorting by % value by an easy tip.

And it doesn’t involve creating calculated columns and an associated sort column. All you need to do is to create another measure for the category % you want it sorted by and place it in the tooltips. And then you can sort by that measure.

For example in this demo the following measure gives the % of total sales for females and this is placed in the tooltips

TotalSalesAmountFemale% =
CALCULATE ( [TotalSalesAmount], dimCustomers[Gender] = “F” ) / [TotalSalesAmount]

The chart is then sorted by this measure to sort by % Female total sales