Sort by Expression Bar Chart

[ksharpes]

Hello,

I am using the following expression to sort data on my Bar Chart 

Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

Which gives me the below

As the data is showing values from last month vs 6 months ago, if there are no values against the 'group' from last month it doesn't sort it correctly.

How do I get around this?

[sunny_talwar · Accepted solution]

May be try this

Match(Only({1} [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

or

Match(Only({1} TOTAL <[Coverage Group (All)]> [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

[Yoshidaqlik]

Hello

Try:

Min(Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0'))

Regrs

[ksharpes]

Both options worked, I used 

Match(Only({1} [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

Many thanks.