Forum Discussion
Scatter chart - two data points not in date order
Hi Anonymous ,
I have tested your data and could replicate the problem and also understand the grouping by date and legend together and then sorting.
Since last 2 days, I am trying sorting of x axis date with an index column, but somehow it does not allow date.
One more workaround is to use line chart in place of scatter chart, and not use the line color but just the marker color, and sort by date. It works fine even with legend, but you need to specify legend colors manually while publishing the report.
Hope it helps.
Hi Farhan. Originally, I had not applied any sorting to the chart. I added a sort by "Spray Date" and set to "Sort ascending" but the data is still out of sequence as shown in this new screenshot.
If you see that it is grouping the data based on the legends. then it is applying the sorting.
you may want to use another visual if you want your x-axis to be sorted by Date without grouping. You may try out Dual Axis Scatter Chart