Scatterplot X Axis Sort Bug

[Anonymous]

Hi,

I have a scatterplot with X axis being Date, Y axis being count of tardiness, and legend being type of tardiness. What is weird is that with just the X and Y axis, the X axis, Date, is sorted correctly, however, once I added the legend, the sort is messed up. I have looked at the date sort and it is sorted correctly. I tried sorting ascending/descending on the plot itself but it is still messed up.

Anyone experienced the same issue?

Thanks!

[v-frfei-msft]

Hi @Anonymous ,

Could your please sahre  your sample data to me to have a test? Please upload your files to One Drive and share the link here.

[Anonymous · Accepted solution]

Hi @v-frfei-msft 

I could not share the report to you as it contains private information. Nonetheless, I've changed to a stacked column chart instead and it works. 

Thanks!

Daren