Sort not working

[samuel_brierley]

Hi all,

im trying to put together a type of wind gauge using a RADAR Chart. i bviously want the directions to go around in the logical fashion. to acheive this is have done this.

=match([Wind Direction],'N','NNE','NE','ENE','E','ESE','SE','SSE',

'S','SSW','W','WSW','W','WNW','NW','NNW')

the thing is the result is nonse. please attached. any help is appreciated.

p.s i have also tried using an inline load to provide id's to each and sorting on that value. no use.

thanks for any help.

[niclaz79]

Hi, Try this for sort order:

Aggr(Max({1}id),[Wind Direction])

Also, there were no id values for 'SSW' or 'WSW' which causes the above to be a bit off (they return null and end up on top). If you add those the above should work.

[sunny_talwar · Accepted solution]

Try this for the sort expression

=Match(Only({1}[Wind Direction]),'N','NNE','NE','EEN','E','ESE','SE','SSE',

'S','SSW', 'SW', 'WSW', 'W','WSW','W','WNW','NW','NNW')

But do you have extra directions?

[samuel_brierley]

thanks that is correct and yes i had added some additional directions in inline load. oops.

thanks for the help.

[sasiparupudi1]

Add a pick to your sort expression

=Pick(match([Wind Direction],'N','NNE','NE','ENE','E','ESE','SE','SSE','S','SSW','W','WSW','W','WNW','NW','NNW'),1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)

hth

Sasi