Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Hi, I am having the same issue as OP. The dates are out of order on using legend.
Without Legend:
With legend:
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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.