Forum Discussion
Scatter Plot sorting issue when adding legend
Hi Anonymous ,
If you add ‘Legend’, visual will always sort X axis group by ‘Legend’.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Anonymous
If you have a date field, I would use the date hierarchy and drill down.
If not i would create one and use as hierarchy.
And on top of the chart check the marked button in screenshot below, click it once to get the year and quarter.
Still the issue is not solved
Anonymous the issue remains the same.
HI Anonymous
Observe closely the icons and names next to the image below as in my case. Bottom four icons and names are auto generated for a date data type. You don't have to do it manually.
Your data type has to be of type date as in below case. You are getting the issue as you have data type other than date.
Anonymous , do you have sort column defined for qtr year. this format will not sort
Qtr year sort = format([Date],"YYYYQ")
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
Now you can sort your qtr column
I have sorted the quarter column it works perfectly fine with Line Chart or any other chart but not with Scatter plot. I did try wat u gave still the same issue persist.
