Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom sort on x-axis

Hi there,   I have spent several hours trying to get my column chart displaying the columns in the right order. I have this chart: But I need it to sort the x-axis as follows: Response ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could transform data then add index column.

    Then click Response column and sort by Index column.

    Set sort axis.

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could transform data then add index column.

Then click Response column and sort by Index column.

Set sort axis.

The final output is shown below:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • 22LACMT's avatar
    22LACMT
    Helper III
    3 years ago

    Thank you for the above. however, my selections in my visuals seem to be different.  Is there something I need to do for it to apear?