sorting legend based on two criteria

[mojganmeibodi19]

I have a simple dataset that contains each supplier's sale in each year. I made a bar chart with years in the x axis and suppliers' sale on the y axis and used supplier company as legend.

I want to sort the legend (suppliers) in each bar (year) based on the total sales of that supplier in that specific year.
I can sort them by all-time total sales of suppliers, but I dont know how to do this sorting in each year.

[josef78]

Try Ribbon chart, and set transparency on connectors....

[lbendlin]

@mojganmeibodi19 I think @josef78 's proposal is the best answer.

[lbendlin]

Not possible in the standard visual.  May not even be possible in Deneb unless @dm-p has an idea.

[dm-p]

Vega and Vega-Lite don't have sorting capabilities for more than one field using standard language constructs, but you can use transforms and window functions to create fields that dictate a sort order that you can then sort by.

[lbendlin]

Could you layer the individual columns as separate marks with their own sort order? Or would you have to know the number of columns/marks beforehand?

[dm-p]

Whatever the layer, if they share the same encoding channel, Vega will likely resolve them to the same scale (and sort). Your best bet would be to use a window transform to generate a numeric order based on grouping and sorting of multiple fields in the dataset and then sort on that.