Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |