Line chart x axis formatting for months

[VinayakKarne]

Hi Team, I am facing issue for ordering the months on x-axis of line chart. The month names are in Text data type. Below is the image of the data which i am getting result and the image in which format i needed.

Resulted dataRequired Format Data

[aoliver]

try this:

In the top right corner, you should have a option for order, select month instead of sthe amount. 

[VinayakKarne]

Yes i tried it. Since the months are in text datatype. So it is arranging in asseniding or decending orger of alphabets of Months.

[aoliver · Accepted solution]

OK,

Next step, order it by number of month, lets explain how:

In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.

tell me if works 🙂