Ordering issue on a visual

[Ayupchap]

I am trying to sort by quesiton but as you can see its not quite working out.  Is there anythign I can do to fix this?

[Vvelarde · Accepted solution]

@Ayupchap

Hi, you need a extra column with the order.

Demo:

Question   Order

Question 1   1

Question 2   2

Question 10   10

After that go to modeling Sort By Column and Select Order Column.

[Phil_Seamark]

You can probably use the Query Editor to help you with this.

Highlight the column wtih the the text "Question 1" etc, then click the Transform tab and then the Split Column button to split by delimiter.

This will give you a new column with just the number component (so long as your data is consistent)

You can then set this solumn to be numeric and use this as your "Sort By Column" back in Power BI