'Sort' tub in Chart properties

[Anonymous]

Hi,

I need to set an expression in Chart properties on 'Sort' tub.

I would like to set a specific order of values for a dimension like =ValueList('ValueX','ValueA','ValueU')

But the function ValueList doesn't have any affect on the Chart.

Could you please give advice?

Thank you in advance,

Larisa

[MK_QSL]

Try below

Only({1}Pick(Match(YourDimension,'ValueX','ValueA','ValueU'),1,2,3))

[sunny_talwar · Accepted solution]

Manish do we need Pick here? Match itself won't be enough?

[#4]

Hi Larisa, I try and also I can't.

You should try to add an id_number for each value in the script, doing this:

value , id_number

'x'      , 1

'a'      , 2

'u'      , 3

and then in the tab 'Order' order by expresion and put this: =id_number (ascending or descending like you prefer)

I hope that it help you!

Agustín