Sort the Legend in specific order

[BoXiangWang]

Hi experts,

I have a bar chart and I want to sort the legend by specific order. 

I need the specific color so I use the master item to set up the color palettes.

I found that I can use the following expression in the master item and it will show the order ascendingly.

Pick(Match(YOS_group, '<1 yr', '1-5 yrs', '6-10 yrs', '11-20 yrs', '21-30 yrs', '>30 yrs', 'NA'),
1,2,3,4,5,6,7)

However, the legend labels become the sequence.

I tried to use the reverse way to match the sequence and back to my original labels but failed.

Could you tell me how can I solve this problem? Thanks.

[VBD]

Hello, If you try to write your fomula just in the sort expression  ?

Exemple below :

Regards,

[ChannaK]

try dual function

[BoXiangWang]

Thanks, I did that but still not successful.

=
Pick(Match(YOS_group,'<1 yr', '1-5 yrs', '6-10 yrs', '11-20 yrs', '21-30 yrs', '>30 yrs', 'NA'),
1,2,3,4,5,6,7)

[BoXiangWang]

Yes, I did check that but don't know how to manage it.

[anat]

Use Dual function or create inline load like YOS_Group, YOS_Group_Sort then use YOS_Group_Sort field for order