Custom Sort Axis

[Anonymous]

Hi all, i have a table of customer satisfaction as below

I would like to build a bar chart of count of response per question and its response detail as below;

my question is, how can I sort the X-axis, so that it based on order as below
1. Very Satisfied
2. Satisfied
3. Neutral
4. Dissatisfied
5. Very Dissatisfied

Thank you

[Anonymous · Accepted solution]

Hi @Anonymous 
you can make an index table with these values. 
Something like

Index	Response
1	Very Satisfied
2	Satisfied
3	Neutral
4	Dissatisfied
5	Very Dissatisfied

  then click on Response column and sort it by using the Sort By section and clicking on Index column

then you can drag this column in the axis of the bar chart.

[22LACMT]

how do you stop the auto stop on the visual level ? 

[Anonymous]

Thanks @Anonymous for your answer. What I did id unpivot the question column and create other response table to sort the axis. Thanks again!

[Anonymous]

No problem 🙂

[22LACMT]

after I do this.  the sort feature within the visual keeps trying to resort and wont allow my custom sort to show.  how do disable this auto sort within the visual that is overriding my custom sort?