Sort PowerBI Matrix table

[Suzie_Suze_Sue1]

Hi,

I am trying to sort a matrix table in number order, however it is a survey, so the matrix looks like this for column one as they are questions

1. How good are the.... ?

10. How clear were ...?

This continues up to

19. How well...?

Then jumps back to Question 2

2.

20.

21.

I have tried an index to sort, tried adding another column and sorting but just seem impossible and I am wasting so much time google and checking google and forums and there doesn't seem to be any correct answer that work.

Any ideas?

Thanks

[Suzie_Suze_Sue1]

Thank you. The 01,02,03 did it!!! Quick and easy 🙂

[amitchandak · Accepted solution]

@Suzie_Suze_Sue1 , I am assuming question number description are togther.

One way is have only question number and mark that as sort column,

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Other wise, split it power query based on . Then Pad 0 and create 2 digit number like 01, 02 and so on and then again combine question number an description

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Power Query- Text.PadStart and Text.PadEnd: https://youtu.be/SNAB6XZ8q74

Append the two column = [Column1] & [Column2]