Forum Discussion

bumoverflow's avatar
bumoverflow
Frequent Visitor
1 year ago
Solved

X axis sort in scatter chart

Hey everyone, I’m having a hard time trying to sort the X-axis by year in descending order. The column used as the X-axis is of number type. Do you have any idea why this might be happening?

 

 

  • bumoverflow's avatar
    bumoverflow
    1 year ago

    Hello,

    For some reason toggling this option worked and x axis is now sorted in correct way

     

     

     

5 Replies

    • bumoverflow's avatar
      bumoverflow
      Frequent Visitor

      Thank you for your response. This is a default visual. It is not just about flipping the x axis, it is not in correct order in any way.

      2023, 2025, 2022, 2024, flipping it would make no sense 😞

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Thankyou, Greg_Deckler, for your response.

    Hi bumoverflow,

    Thank you for your follow-up.

    From what I understand, the X-axis (Year) in your scatter chart is not sorted properly. This usually happens when the axis is treated as a category.

    Please follow these steps which may help solve the problem:

    1. Make sure the Year field is a number, which looks correct from the image you shared.
    2. Go to the X-Axis settings in your scatter chart and set the Type to Continuous (not Categorical). Then use the 3-dot menu to sort by Year, and choose either Ascending or Descending order.

    I have attached a screenshot and a sample pbix file that might help you fix the issue:

    If my response helps you, please mark it as the accepted solution and give kudos. This will help others in the community with similar questions.

    If you have any more questions, feel free to ask the Microsoft Fabric community.

    Thank you.




  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Hi bumoverflow,

    We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

    If you find the response helpful, please mark it as the accepted solution, as this will help other members with similar queries.

    Thank you.

    • bumoverflow's avatar
      bumoverflow
      Frequent Visitor

      Hello,

      For some reason toggling this option worked and x axis is now sorted in correct way