Scatter chart - issue with date order

[Anonymous]

Hi all,

I just wanted to raise an issue that I’ve encountered with date orders in relation to the scatter chart in Power BI.

Essentially, my problem is that, whenever I populate the “legend” element of the graph, it completely scrambles the date order. The date order is absolutely fine when the “legend” is empty. Please see the examples below, first with the legend empty and then with the legend populated:

Please note that this is using a custom date table.

I was wondering if anybody could advise where I’m going wrong here?

Many thanks!

Adam

[Anonymous]

Hi, I am having the same issue as OP. The dates are out of order on using legend.

Without Legend:

With legend:

[v-lili6-msft]

hi, @Anonymous 

I have test on my side, it works well.

And "legend" value shouldn't affect the order of x-axis. If you try to change the sort of visual as below；

If you still have the problem, please share a simple sample pbix file.

You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Anonymous]

Hi Lin,

Thank you for getting back to me, apologies for the delayed reply.

I have a test file but don't believe that I can post a link to it here via OneDrive as it would expose my company's internal OneDrive site - is there an alternative way that i can post a Power BI file for general access?

Many thanks,

AJS