topic Re: sorting legend based on two criteria in Report Server

sorting legend based on two criteria

mojganmeibodi19 — Tue, 06 Feb 2024 07:52:49 GMT

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.

Re: sorting legend based on two criteria

lbendlin — Wed, 07 Feb 2024 00:22:25 GMT

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

Re: sorting legend based on two criteria

dm-p — Wed, 07 Feb 2024 01:56:58 GMT

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.

Re: sorting legend based on two criteria

lbendlin — Wed, 07 Feb 2024 02:27:19 GMT

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?

Re: sorting legend based on two criteria

dm-p — Wed, 07 Feb 2024 02:31:30 GMT

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.

Re: sorting legend based on two criteria

josef78 — Fri, 09 Feb 2024 17:43:01 GMT

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

Re: sorting legend based on two criteria

lbendlin — Fri, 09 Feb 2024 18:11:20 GMT

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