Forum Discussion

Suzie_Suze_Sue1's avatar
Suzie_Suze_Sue1
Helper I
3 years ago
Solved

Sort PowerBI Matrix table

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 ...?...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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]

amitchandak's avatar
amitchandak
Super User
3 years ago

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]