Forum Discussion

VoltesDev's avatar
VoltesDev
Helper V
4 years ago
Solved

How to make column for sorting ?

Hi, In my table I have rows values which has no sort in its data source (direct query), as below: ColumnA High Medium Low   So I figured I must create new column and create some so...
Need Help
Tips and Tricks
  • KNP's avatar
    KNP
    4 years ago

    I prefer to do my data modelling in Power Query.

    Hope this helps.

     

KNP's avatar
KNP
Super User
4 years ago

I prefer to do my data modelling in Power Query.

Hope this helps.

 

  • VoltesDev's avatar
    VoltesDev
    Helper V
    4 years ago

    Hi KNP 

     

    Thanks, it works very well.

     

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    You could also key in the Sort column by modifying the Source step rather than defining a custom column (assuming the table was created in the query editor to begin with, of course).

    • VoltesDev's avatar
      VoltesDev
      Helper V
      4 years ago

      Hi,

       

      Sure, but I'm using Direct Query (which I didn't tell in this thread). So have limitation of modifying source, especially cannot add table.

       

      Thanks

  • 22LACMT's avatar
    22LACMT
    Helper III
    3 years ago

    Thank you this helped me. however, the data on my visualization is not showing the results from the new data arrangement.  what am I missing? 

     

    Thank you

    • KNP's avatar
      KNP
      Super User
      3 years ago

      Probably best to open a new question.

      You can reference this thread and tag people to get their attention. 

      Replying to solved threads will often not get a response.