Forum Discussion

valcat27's avatar
valcat27
Helper III
5 years ago
Solved

Sort chronologically x axis based on date and time column

Hello all,    I built a scatter chart with a date and time column on the x axis, but I am having some problems sorting it by date. I have already tried to adapt some solutions for similar problems ...
Need Help
  • valcat27's avatar
    valcat27
    5 years ago

    Hello Anonymous ,

     

    Thank you for your answer. 

    Comparing with your data, I thought everything was equal, but then I noticed that the problem was related to the legend. In fact, when I excluded it, dates are sorted chronologically.

     

    I think the problem is related to the model structure. The chosen column for the legend is from another table.  This table is not connected directly to the table that I'm using for the values on the y and x axis and the relationship between both tables are many to many.  Now I'm trying to recreate the model to be possible to include the legend and keep x axis sorted chronologically.

     

    Best regards,

valcat27's avatar
valcat27
Helper III
5 years ago

 Pragati11 and parry2k thank you for your answers. 

 

The data that I can share is a bit limited, but I hope it is sufficient. 

1)The figure below shows how the visual looks like and, as you can see, x axis is not sorted chronologically.

 

2) To sort the visual, on “More options” (…), I selected “Sort ascending” and “Sort by date column”.

 

3) On data tab/section, selecting the date column, in the table, I can verify that values are sorted chronologically and the column type is Date/Time.