Forum Discussion
Sorting Text and Number in one sentence
Klik What has to be done is click on the column(that has to be sorted) in data pane and this will open column tools tab. On that there is an option to sort column by, select the new numeric column. This will sort the column that has to be sorted on the basis of the new column that was create.
P.S. this is done in PowerBI not query after the additional numeric column is created.
Thank You
Solution SageKlik this will require an additional numeric column, if the column is present then click on column and in column tools sort by that numeric field.
If there is no numeric column that can sort the data. Go to Power Query and duplicate the milestone column and then use split group [By digit to non-digit] and change the type of number column from text to number, this can serve as milestone ID and then it can be used as stated above.
Thank You
Hello ChiragGarg2512,
Thank you so much, I really appreciate your response to my question.
However, I want to ask you, what can i do after adding the column.. I didnt want the sortcolumn to appear in my table.. but if I untick it will go back to its unsorted numerical order...
- ChiragGarg2512
Klik What has to be done is click on the column(that has to be sorted) in data pane and this will open column tools tab. On that there is an option to sort column by, select the new numeric column. This will sort the column that has to be sorted on the basis of the new column that was create.
P.S. this is done in PowerBI not query after the additional numeric column is created.
Thank You
Thank you soo much ChiragGarg2512 it worked!!!
