There would appear to be a definite problem in the Scatter Chart visual where sorting has been set by the value on the X-Axis, and there is a specified category in the "Legend".
The sorting appears to change the defined sort order to include the category first when there is a null for either of the category. I have attached the sample solution here SAMPLE
The solution shows that the visual is definitely set to order by the Month/Year.
Remove the legend field and the scatter shows the X-Axis in order correctly.
Add back in the legend and the scatter would appear to be sorting by Legend/X-Axis.
The data behind the Visual is sorted perfectly - not just the Visual.
I dont see why it wouldnt be able to show in the order specified to be shown.
5 Comments
shaunwilks wrote:
There would appear to be a definite problem in the Scatter Chart visual where sorting has been set by the value on the X-Axis, and there is a specified category in the "Legend".
The sorting appears to change the defined sort order to include the category first when there is a null for either of the category. I have attached the sample solution here SAMPLE
The solution shows that the visual is definitely set to order by the Month/Year.
Remove the legend field and the scatter shows the X-Axis in order correctly.
Add back in the legend and the scatter would appear to be sorting by Legend/X-Axis.
The data behind the Visual is sorted perfectly - not just the Visual.
I dont see why it wouldnt be able to show in the order specified to be shown.
What's the "specified order" you mentioned? Could you please share more details?
Regards,
Jimmy Tao
I am not sure what else you need - I supplied a link to a sample PBIX that shows the issue.
The sorting for the visual is by the Month-Year.
The Data Behind the visual orders correctly.
The Visual itself though and the X - Axis is not in the Month Year order its being told to sort in.
It appears as though the Visual sorts by the legned field first, then Month-Year.
This is incorrect
Sorry for late, I have reproduce this issue and will report this issue to power bi team. I will update here once I get any info.
Regards,
Jimmy Tao
This is an existing bug and power bi team will try to prioritize it for the next release.
Regards,
Jimmy Tao
Hi, any update on this? I have just ran into the same problem.
