Order text on x-axis

[J_H]

I'm trying to create a column chart (specifically 100% stacked column chart). The labels along my X-axis are sample names, however when I create a chart Power BI creates what appears to be a random order and doesn't follow the order of the data table. The sample names contain both numbers and letters so are inputted as text values, and selecting "Sort by column" doesn't help. If I remove the letters, leaving just numbers, it arranges it numerically (which is fine) but leaves massive gaps along the number line because the nature of the samples means they're not consecutive numbers.

I've also tried creating a column of numbers and using "Sort by column" to sort the sample name column by the number...but no luck. 

Suggestions?

[GilbertQ]

Hi there,

You could possibly create an Index Column in Power Query on your table.

And then use this Index Column as your "Sort By Column" on your field? That should then create it in the correct order.

[CheenuSing]

@J_H

Is this what you are expecting or anything different. 

Cheers 

CheenuSing

I tried with my test table created based on your problem and i see the result as 

[J_H]

Thanks @CheenuSing

Yes, and my issue was I needed it in particular order e.g. Sample 1, 1Gsample, 20 Test etc. using your example.

However I've gotten it to work using the "Sort by column" function, which I'd tried before so I don't know why it suddenly decided to work, but it does.

In case anyone else needs it: highlight the column of your x-axis data and select "Sort by column" then choose the column of numbers which are in the desired order.