Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Suzie_Suze_Sue1
Frequent Visitor

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 ...?

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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]

View solution in original post

2 REPLIES 2
Suzie_Suze_Sue1
Frequent Visitor

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

amitchandak
Super User
Super User

@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]

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors