Forum Discussion

Anonymous

Not applicable

5 years ago

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...

Icon for Super User rank

Super User

5 years ago

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

Anonymous
Not applicable
5 years ago
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
  Super User
  5 years ago
  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
  - Anonymous
    Not applicable
    5 years ago
    Pragati11 hi, this is the pbix link. im not sure why it doesn't work only for scatter. If I change it to line or bar chart, it sorted month in order. but i needed a scatter chart. Please help https://1drv.ms/u/s!AoKh3nlpMpSOgmSAg1TMiavknFhn?e=NDMg6m