Sort issue in X axis Scatter Chart

[Renjith]

Hi

This is my dataset. I have sorted days column by order column

My requirement is to create a scatter plot with X axis as days values as result and legend as id , but currently I am facing an issue is x axis values are not coming in a sorted way my current output is

Is there anyway to resolve this

My expected output is

 

[v-alq-msft · Accepted solution]

Hi,

For your expected output, it is unsupported to use a scatter plot to get expected result. However, it is available to use line chart as a workaround. You can achieve the same  effect by a line chart. The steps are as follows:

1.I sort days column by order column. Make sure the days column is selected and I choose the order column in ‘Sort by column’.

 2.I choose ‘Line Chart’ in Visualizations and configure Axis, Legend, Values :

 3.Make sure that the ‘Type’ property of X axis in Format is ‘Categorical’ :

 4. Finally, the result visual will be shown as your expected output.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello, I have a similar issue, but I need to use the sizing of dots option in the scatter plot. Therefore, I cannot switch to line chart. Is there a solution for sorting in scatter plot in the meantime? 

[Renjith]

Thanks Allan, I m also working on the same