Forum Discussion
Unable to sort by month when using scatter chart
Hi. I'm using scatter plot for my report. I want to sort by month. Everything works fine until I select the legend.
Picture below is when I remove legend.
Picture below is when I put the legend.
I tried to re-do it again, just in case if I'm mistaken anywhere, but it still shows the same error.
But if I'm using other types of chart, the order of month is correct. Can anyone help me with this? Why does this went wrong?
8 Replies
- Pragati11
Super User
Hi Anonymous ,
There are multiple threads for this issue in this forum. See one below:
https://community.powerbi.com/t5/Desktop/Sort-month-name-by-month-number/m-p/1515201
Thanks,
Pragati
Pragati11 hi, can you help me with this? https://community.powerbi.com/t5/Desktop/Unable-to-sort-by-month-when-using-scatter-chart/m-p/1607957#M650042
- Pragati11
Hi Anonymous ,
I tried something similar at my end. Below chart is witout LEGEND have got month in right sort order:
Now, when I move LEGEND to it I still get my MONTH sorted in the right order:
As I can't reproduce this issue at my end, Can you share you sample pbix file for this with both the charts on it - one with LEGEND, one without LEGEND?
Thanks,
Pragati
