Forum Discussion
J_H
9 years agoNew Member
Order text on x-axis
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 o...
Anonymous
9 years agoNot applicable
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
9 years agoNew Member
Thanks Anonymous
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.