Forum Discussion
Klik
2 years agoFrequent Visitor
Sorting Text and Number in one sentence
Can anyone help me on how can I sort my data accordingly like the expected below table. I really appreciate the help. Expected: Milestone: M1 M2 M3 M4 M5 M6 M7 M8 ...
- 2 years ago
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