Skip to Content
0
Nov 05, 2019 at 09:34 AM

Sort a Stacked Bar/Column Chart by Total

1177 Views Last edit Nov 05, 2019 at 08:05 AM 2 rev

On my story, I have a stacked bar/column chart.
This chart takes its data from a model which is connected to a live source.
I want to sort it by the Total of the stacks, from the Highest to Lowest.
But until now, I didn't find any ideal solutions.

I found one solution, but it wasn't really ideal:
I added a new Calculation which contains the sum of all the stacks.
I added this Calculation as a measure to the Graph and sorted the graph by the Calculation.
This works, but now I have the sum of the stacks as an extra stack and the totals of each whole bar is now doubled.

And when I'm sorting the graph by the Calculation without adding the Calculation as a measure, the graph won't sort.

Is there another, better solution?

Attachments

not-sorted.png (9.9 kB)
sum-and-sorted.png (10.7 kB)