Forum

Custom Sorting in P...
 
Notifications
Clear all

Custom Sorting in Power BI

2 Posts
2 Users
0 Reactions
147 Views
(@zmas)
Posts: 1
New Member
Topic starter
 

Hi,

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 🙂

Thanks! 

 
Posted : 02/09/2022 3:20 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Hi Zied,

Your example contains five possible answers. Is this how you would want to sort them?

Very satisfied
Satisfied
Dissatisfied
Very dissatisfied
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.

Riny

 
Posted : 02/09/2022 3:49 am
Share: