Sorting on Bar/Line Chart

[kaylaramsey2]

My bar/line chart is not sorting correctly.  I see my issue.  The dates are only sorting where the line bar starts.  How do I force the whole chart to sort correctly?

[sergio0592]

In properties/Sort , you can use sort by expression and use match() :

=match(YourField,'201701','201702','201703','201704','201705',.....)

[kaylaramsey2]

Hi this will not work.  This chart is going to continue growing everytime we add more data.  Doing a match would be very manual.

[Frank_Hartmann · Accepted solution]

Maybe with this sorting expression:

num(Date#(YourDateField,'YYYY-MMM'))

hope this helps

[MarcoWedel]

please post a sample application that demonstrates the issue.