Forum Discussion

valcat27's avatar
valcat27
Icon for Helper III rankHelper III
5 years ago

Scatter plot- add legend removes the X axis ordering

Hello all,   I created a scatter plot that is defined to be sorted by x-axis, but when I add the legend, it is no longer ordered correctly.    For a better understanding, imagine that I want to o...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, valcat27 ;

I am not very clear about your meaning and scenario, can you share similar screenshots or more information about your question? After my test, if the X-axis and Y-axis are of Whole Number and Decimal Number, it is automatically sorted according to the size of the number,such as the below:

If you change the ProductID type to "text", the sort and the chart will change also.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

valcat27's avatar
valcat27
Icon for Helper III rankHelper III
5 years ago

Hello v-yalanwu-msft ,

 

Thank you for your answer.

 

Defininig ProductID as text, it does not work because it sorts it considering only the first digits and ignoring how many digits the number has. It sort is like this: 12345, 124,15, 2357, 274...

 

With the productID as Whole Number type, I selected the type of the x-axis as categorical to avoid overlapping values. As you can see in the following figure, the values are not all sorted. It looks like they are sorted for some groups/periods. (The visual was selected to be sorted by ProductID and ascending).