Imporssible to sort my values in order

[Anonymous]

Hi Everyone, 

I have  little problem : i cant sort my values in order. Don't understand why i didnt get the option ? 

I would like to order small value country at first and bigger on the top..

Anyone know ?

Thanks in advance for help ! 

[Greg_Deckler · Accepted solution]

Yeah, I am not aware of that option in the stacked column chart. What it is doing is sorting the stacks alphabetically according to the legend. If you have multiple values, it sorts the stacks by the order of the values in the Values area. I can't see how your stacked column chart is configured but I am guessing that you are using Legend.

So, you can get around this by creating a Sort By column for what it looks like is a Country column that you are using in your Legend. This can be numeric and be whatever order you choose it to be so you can kind of work around this. But, not dynamic in that if for some reason in one of your stacks some country overtakes another as biggest, that won't be reflected dynamically.

There are other visuals that do a better job of this like the Ribbon chart visual so that you can see how things ebb and flow over time.

[Greg_Deckler · Accepted solution]

Yeah, I am not aware of that option in the stacked column chart. What it is doing is sorting the stacks alphabetically according to the legend. If you have multiple values, it sorts the stacks by the order of the values in the Values area. I can't see how your stacked column chart is configured but I am guessing that you are using Legend.

So, you can get around this by creating a Sort By column for what it looks like is a Country column that you are using in your Legend. This can be numeric and be whatever order you choose it to be so you can kind of work around this. But, not dynamic in that if for some reason in one of your stacks some country overtakes another as biggest, that won't be reflected dynamically.

There are other visuals that do a better job of this like the Ribbon chart visual so that you can see how things ebb and flow over time.

[Anonymous · Accepted solution]

It was a better idea, it's really better with a ribbon ! 

Thanks for the advice and have taking time for me, 

Wish you the best !