Forum Discussion
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 ...
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.
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?
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