Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Sort Axis

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, h...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    No problem 🙂

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

      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?