topic Re: Sorting Text and Number in one sentence in DAX Commands and Tips

Sorting Text and Number in one sentence

Klik — Wed, 04 Oct 2023 04:30:31 GMT

Can anyone help me on how can I sort my data accordingly like the expected below table. I really appreciate the help.

Expected:

Milestone:

M10

M11

M12

M13

M14

M15

M16

M17

M18

M19

M20

M21

M22

M23

M24

M25

M26

M27

M28

M29

M30

M31

M32

M33

M34

M35

M36

Outcome:

Milestone:

M10

M11

M12

M13

M14

M15

M16

M17

M18

M19

M20

M21

M22

M23

M24

M25

M26

M27

M28

M29

M30

M31

M32

M33

M34

M35

M36

Re: Sorting Text and Number in one sentence

ChiragGarg2512 — Wed, 04 Oct 2023 04:40:59 GMT

Klik 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

Re: Sorting Text and Number in one sentence

Dangar332 — Wed, 04 Oct 2023 05:39:33 GMT

hi, Klik

add new column
sort column = LEFT(RIGHT(sort[Milestone: ],LEN(sort[Milestone: ])-1),1)

which look like

add your milestone column to table visuals which automaticaly sort by as you want

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Re: Sorting Text and Number in one sentence

Dangar332 — Wed, 04 Oct 2023 05:55:12 GMT

hi, Klik

i use your same data . for me table visual automaticly sort data as you want

if not work for you then refer my reply in same post

Re: Sorting Text and Number in one sentence

Klik — Wed, 11 Oct 2023 04:09:02 GMT

Hello dangar,

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...

Re: Sorting Text and Number in one sentence

Klik — Wed, 11 Oct 2023 04:10:02 GMT

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...

Re: Sorting Text and Number in one sentence

ChiragGarg2512 — Wed, 11 Oct 2023 05:11:19 GMT

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

Re: Sorting Text and Number in one sentence

Dangar332 — Wed, 11 Oct 2023 05:09:00 GMT

hi, Klik

you want sorted data in your table view?
if yes follow below
(1) right click on your column

(2) click on ascending

you get your answer

Re: Sorting Text and Number in one sentence

Klik — Wed, 11 Oct 2023 07:11:32 GMT

Thank you soo much ChiragGarg2512 it worked!!!

Re: Sorting Text and Number in one sentence

Klik — Wed, 11 Oct 2023 07:12:49 GMT

Thank you so much Dangar332 the problem has been solved! Appreciate you help!!