Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
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 : )
It's a bit annoying but having a specific set of customization often requires those workarounds in the tool 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |