Forum Discussion

Helper III

9 years ago

Solved

Ordering issue on a visual

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?

Community Champion

9 years ago

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.

Microsoft Employee

9 years ago

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