Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sort unpivot attributes by question order

Hello,   I am dealing with survey data (Questions and Answers). My particular problem is sorting the questions in order after unpivoting. When I unpivot all the questions they get placed in a new ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    I figured it out. The values quere different from each other in the relational table and that is why ti wasn't working. 

     

    Thanks for the help! 

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

You could use Sort by column in Power BI Desktop to achieve your requirement.

Before it, you need to add an index column for attributes column by your logic.

 

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-lili6-msft Thanks for the suggestion. 

 

I have created an index column and attempted to sort by that order but it doesn't work as intended. What it does it assigns a duplicate numbers to the answer rows and that is making the order wrong. I also tried to use the related table with just the answers and a index column and that does not work ether. Any other ideas?

 

Here is how the data is being ordered: 

 

 

Thanks again.