topic Re: How to order a Scatter chart by - X axix in DAX Commands and Tips

How to order a Scatter chart by - X axix

enavesca — Mon, 25 Mar 2024 04:38:13 GMT

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

Re: How to order a Scatter chart by - X axix

lbendlin — Mon, 25 Mar 2024 19:53:42 GMT

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

Re: How to order a Scatter chart by - X axix

Anonymous — Tue, 26 Mar 2024 09:22:17 GMT

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