Scatter Plot sorting issue when adding legend

[Anonymous]

Hi Team,

here is my requirement: 

Need to plot period on X axis (Drill down from year-qtr-month) and Amount on Y axis in a scatter plot. when we hover over the bubble the product name should appear.

For sorting of the month i have cretaed a month sort coulmn (Year*100+month_number), Qtr is sorted based on the year (Qtr value is like Qtr 1 2019, Qtr 2 2019 ...)

Same year,quarter,month can have multiple products so have added the product name in the legend, this is resulting in wrong sorting of the X axis.

Untill we add Product in the legend the sorting is perfect but as soon as we add product its sorting on the legend.

I have tried sort by year also, sort ascending descending also. Wrong Sorting after adding legendWhen legend is removed sorting is correct 

[pranit828]

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.

[Anonymous]

Still the issue is not solved

@pranit828  the issue remains the same.

[pranit828]

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.

[amitchandak]

@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

[Anonymous]

@amitchandak 

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-msft · Accepted solution]

Hi @Anonymous ,

If you add ‘Legend’, visual will always sort X axis group by ‘Legend’.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.