September 1, 2022
I am working with survey data and I am having issues custom sorting it on Power BI.
Every respondent picks a satisfaction level (very satisfied, dissatisfied, etc.) for dozens of questions. When I present the data in bar graphs, they do not show up in the normal and desired order (from the most satisfied to the most dissatisfied). I understand that the trick in Power BI is to create a sort order table, link the two tables and do it that way. However, in order for this trick to work, I would have to create a sort order table for each survey question and link them. With over 90 questions, this would turn into a mess.
Attached is a sample of what my data looks like, but with hundreds of responses and over 90 questions.
Please let me know your thoughts 🙂
January 31, 2022
Your example contains five possible answers. Is this how you would want to sort them?
|I did not use this service|
If so, perhaps the attached workbook could achieve what you ask for. I created a SortOrder table, unpivoted the Answers table and merged each answer with its sort order. Then, I loaded the table back to a Pivot Chart.
Come back here if this is not what you had in mind.