Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Scatter chart - issue with date order

Hi all,

 

I just wanted to raise an issue that I’ve encountered with date orders in relation to the scatter chart in Power BI.

 

Essentially, my problem is that, whenever I populate the “legend” element of the graph, it completely scrambles the date order. The date order is absolutely fine when the “legend” is empty. Please see the examples below, first with the legend empty and then with the legend populated:

 


 

Please note that this is using a custom date table.

 

I was wondering if anybody could advise where I’m going wrong here?

 

Many thanks!

 

Adam

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, I am having the same issue as OP. The dates are out of order on using legend.

     

    Without Legend:

    With legend:

     

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    I have test on my side, it works well.

    And "legend" value shouldn't affect the order of x-axis. If you try to change the sort of visual as below；

     

    If you still have the problem, please share a simple sample pbix file.

    You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Lin,

       

      Thank you for getting back to me, apologies for the delayed reply.

       

      I have a test file but don't believe that I can post a link to it here via OneDrive as it would expose my company's internal OneDrive site - is there an alternative way that i can post a Power BI file for general access?

       

      Many thanks,

       

      AJS