Forum Discussion
Scatter Plot sorting issue when adding legend
- 5 years ago
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.
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.
- v-lionel-msft5 years agoCommunity Support
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.