Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Scatter Plot sorting issue when adding legend

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 

 

 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Still the issue is not solved

      Anonymous  the issue remains the same.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.

         

  • Polo1234567's avatar
    Polo1234567
    Regular Visitor
    1 year ago

    Sorry to dig up this subject but I have the exact same type of vizualisation and anomaly and the "solution" is juste a confirmation of the issue...

     

    Is there somebody who has a solution to this problem ? Thanks in advance