Numerical order out of line in x-axis - separate sorting table?

[juliamacg_]

Hello, team,

As you can see in the image, I have a line chart with an x-axis in ascending order but the numerical order is not obeyed. I found this article in the forum regarding a similar issue and the solution proposed is to create a separate sorting table, but it is not clear to me how that should be done. Could anyone help me with this?

Thank you so much!

[Jayee · Accepted solution]

Hi @juliamacg_ ,

You can create another table or another calculated column also fine the data should be unique to the value you have used in the X-axis.

Example: a field value is <100 das then b field value is 100 (100 is a number type it works)

Then you can follow the steps in the article

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[juliamacg_]

This indeed worked, thank you for the help!