cancel
Showing results 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

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
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:

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

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

2 REPLIES 2
Frequent Visitor

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

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:

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

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

Announcements

#### 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 Monthly Update - June 2024

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

#### 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
Top Kudoed Authors