How to sort likert scale legend for multiple columns?

[Anonymous]

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:

Response	Q1	Q2	Q3	Q4	Q5	Q6
1	Disagree	Neither Agree nor Disagree	Agree	Neither Agree nor Disagree	Strongly Agree	Neither Agree nor Disagree
2	Strongly Agree	Disagree	Strongly Agree	Neither Agree nor Disagree	Strongly Disagree	Neither Agree nor Disagree
3	Strongly Disagree	Strongly Disagree	Agree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree
4	Agree	Strongly Disagree	Strongly Agree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree
5	Neither Agree nor Disagree	Strongly Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree
6	Agree	Strongly Disagree	Agree	Neither Agree nor Disagree	Disagree	Neither Agree nor Disagree
7	Disagree	Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Agree	Neither Agree nor Disagree
8	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Strongly Agree	Disagree
9	Strongly Agree	Agree	Agree	Agree	Neither Agree nor Disagree	Agree
10	Agree	Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Neither Agree nor Disagree	Agree

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! 

[ray_aramburo · Accepted solution]

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]

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]

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