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.

     

darshaningale's avatar
darshaningale
Resolver II
4 years ago

Create a new conditional column "Sort/Order" in powerquery based on x-axis column and use the new column as Sort for x-axis.

 

 

 

Regards
DI

Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I dont want to sort my master table with a new column, because for another visual, I will need to sort on another column, if that makes sense?

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Create a dimension table for the values in the axis and add the sorting order column using SWITCH. Sort the values by the sort order column and then use this field as the axis