How to order a Scatter chart by - X axix

[enavesca]

Hello everyone,

I would like to order the X axis by "Size Desc", from smallest to largest (XS, S, M, L, XL).

I've attempted to order the 'Size Desc' column by the 'Size' column, but it didn't work.

I appreciate any suggestion that solves this problem

[Anonymous · Accepted solution]

Hi, @enavesca 

According to your description, you can check the Size Desc field, then check Size in the Sort by column function of Column tools, the X-axis will be sorted by the size of the Size.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

Nearly there.  Flip your size column around, with XL being 1, L being 2 etc.  "Sort a column by another column"  is always ascending.