Scatter Plot: Legend added destroys the x-axis date order

[OLM]

Good day,

I have the following scatter plot:

y-asix: whole number

x-asix: date (hirerachy)

size: whole number (same field as the y-asix).

Legend: categories of client names(text).

Once I put the legend is distroys the date order. 

None of the search online has yielded any solution.

PLease advise.

As this is business content, I cannot share print screens.

Thank you for your educational enlightment. 

[dk_dk]

Hi @OLM ,

After you added the legend, click on the ... in the corner, Sort by, and select your date field.

For some reason the default behavior seems to be that the legend takes priority over the X-axis in this chart.


Hope this helps!


Best regards,
Daniel

[OLM]

Thank you dear Daniel, I have tried pre-posting here. I wish it was that easy. I am glad you may be helping others in pointing it out. When wanting to sort, it ignores it. Nothing happens sadly.

[dk_dk]

That's strange. If you can maybe upload a .pbix with your data, or a representative sample, I can have a look. Could be something with the datatypes being incorrect such that the sorting does not work as intended?

[OLM]

Sadly I cannot upload dummy data seeing it is highly confidential. Using x-asix date field did not work seeing the sorting was non-reactive. Now the x-asix is a text field date ("mmm-yy") which is sorted by a sortby integer column. And as mentioned, when I press "show as table" the order is kept perfectly, but not in the visual.

[dk_dk]

Can you try to add the sortby integer column to the visual, in the tooltips section, and see if you can sort the visual by that column, as per my screenshot?

[OLM]

Tried to sortby by integer field. Problem is that the legend takes over as ruling sorter and it is impossible to change.