Originally the X-axis was displayed as “1,2,3,4…17,18,19,20”.
It was changed to “1,10,11,12,12,13… . 6,7,8,9”.
This graph gets its legend from the column names in the table, so the field names were changed to “101,102,103… .118,119.120”.
However, the “101,110,111,112… .107,108,109” in that order.
I do not know what is the basis for the alignment.
Please let me know if there is a way to arrange them in numerical order.
I assume that the field you are using for the x-axis is a string. Is that correct?
Previously, there was some “magic” sorting for strings in the old visualizations, which was helpful in some cases but not in others. Now, strings are always sorted following the standard of character sorting.
In your case, the solution would be to create an additional integer or number field that stores your values 1, 2, 3, … and use that for the x-axis instead of the string you are currently using. This will sort the values numerically on the x-axis. As all the strings end in “Average”, this will also make the axis less crowded. Additionally, you can customize the x-axis title in the new formatting panel and add the “average” to it if you don’t want the actual field in the table to be called “Average” or are using an expression to get to the value.