Can you have a sort order

[rpinxt]

So I have this graph and I sorted it by period:

Would it be possible now to sort also the legend with the highest percentages first?

So in this case this would start with the yellow one.

[lbendlin · Accepted solution]

There is no guarantee that the yellow is always the highest.

You can break the bars into individual measures and then add these separately to the values. That allows you to specify the order of appearance - at the cost of totally losing the visual's flexibility.

[Anonymous · Accepted solution]

Hi @rpinxt ,

You will need to create measures for each color instead of using legend.

Then you would sort the chart by specific measure.

However you still can't get it to automatically sort by the highest value, because they are not from the same measure.

And you can't guarantee that yellow will always be the highest value.

Best Regards,

Jay

[rpinxt]

Ok thanks guys.

So bottom line there is no easy/good way to do this and its best to leave it as is 😉

[lbendlin · Accepted solution]

There is no guarantee that the yellow is always the highest.

You can break the bars into individual measures and then add these separately to the values. That allows you to specify the order of appearance - at the cost of totally losing the visual's flexibility.