Dimension order

[Firebird1]

I would like to reorder the Days of the week on the X-axis of my line graph to the days of the week in order (Mon, Tue, Wed, Thu, Fri).  The issue I'm having can be seen below. I've tried sorting the data but can only sort it according to numerical value or alphabetical order.

Is there a fix for this?

[BrunPierre · Accepted solution]

The Weekday() returns a dual value with an integer between 0 and 6 that corresponds to the day of the week (0-6) which you can use to sort the values.

On the sort tab of the chart,  select numeric as sort order.

Alternately, by sort expression as below:

=Match([Day of Week], 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun')

[Firebird1]

Thank you so much for taking the time to reply. This worked for me!