Forum Discussion
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? ...
Hello,
For some reason toggling this option worked and x axis is now sorted in correct way
v-pnaroju-msft
Community Support
Community SupportThankyou, 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:
- Make sure the Year field is a number, which looks correct from the image you shared.
- 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.