Forum Discussion

J_H's avatar
J_H
New Member
9 years ago

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 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?

 

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      J_H
      New Member
      9 years ago

      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.

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    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.