Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to sort likert scale legend for multiple columns?

Hi, I have a survey of about 15 questions, all with an likert scale from Strongly Agree > Strongly Disagree. I'm trying to sort the legend and columns on a 100% stacked bar chart to mirror this order. I can do it for one column by creating a sort table and then doing a related column like so: Q1 = RELATED('Sort'[Sort Table]) but this only works for one column. Do I really need to create multiple sort tables and related columns to achieve this, or is there an easier way to sort all 15 questions from Strongly Agree > Strongly disagree? Below is essentially a very abbreviated version of my source data:

 

ResponseQ1Q2Q3Q4Q5Q6
1DisagreeNeither Agree nor DisagreeAgreeNeither Agree nor DisagreeStrongly AgreeNeither Agree nor Disagree
2Strongly AgreeDisagreeStrongly AgreeNeither Agree nor DisagreeStrongly DisagreeNeither Agree nor Disagree
3Strongly DisagreeStrongly DisagreeAgreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor Disagree
4AgreeStrongly DisagreeStrongly AgreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor Disagree
5Neither Agree nor DisagreeStrongly DisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor Disagree
6AgreeStrongly DisagreeAgreeNeither Agree nor DisagreeDisagreeNeither Agree nor Disagree
7DisagreeDisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeAgreeNeither Agree nor Disagree
8Neither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeStrongly AgreeDisagree
9Strongly AgreeAgreeAgreeAgreeNeither Agree nor DisagreeAgree
10AgreeDisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeNeither Agree nor DisagreeAgree

 

And I'm trying to make this: 

Look like this: 

For all 15 questions without creating multiple sort tables. Is there any way of doing that?

Thank you for any and all help! 

  • Since you have a column for each question and each question requires a different order, indeed you need to have a custom sort column per question. I'd recommend you to create them in Power Query, it's faster and easier. 

3 Replies

  • Since you have a column for each question and each question requires a different order, indeed you need to have a custom sort column per question. I'd recommend you to create them in Power Query, it's faster and easier. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you ray_aramburo - that's what I ended up doing. As long as I don't clog up the data pane with too many tables, that works for me : ) 

      • ray_aramburo's avatar
        ray_aramburo
        Icon for Super User rankSuper User

        It's a bit annoying but having a specific set of customization often requires those workarounds in the tool 🙂