Forum Discussion

Ayupchap's avatar
Ayupchap
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?

 

Need Help
Show and Tell
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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.

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    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's avatar
      Phil_Seamark
      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