Sort by column name

[barabuli]

why do I receive this kind of sorting when it is sorted by Name??

why does  "Up" comes first an then "More"???

I mean first comes words but no alphabet sorting and then comes numbers but not by ascending??

[Anonymous · Accepted solution]

When you sort by ascending on a text column it shows numbers first. And it only sorts by the first element of some text.

An example:

data = beer, 3, 10, 2, axe, cloth.

Sort data by ascending: 10, 2, 3, axe, beer, cloth

Sort data by descening: cloth, beer, axe, 3, 2, 1

These are the possibilities you have when sorting text. but there is a work around for this.

You can make a new column next to your categories, which can be called SortOrder and simply assign 1, 2, 3, 4, 5 and so on, and then sort by the column, either ascending or descending according to your need. 

Let me know if this will solve your challenge. I'll gladly elaborate.

Best

Martin

[Salvador]

Hi,

Idk if you have it set to sort ascending or descending, but if that's a calculated field, you could sort by another column, and... if it's not calculated, you could also create an if column, making an artificial sort, converting thoose names to numbers, and then sort that column by this new one 😄

[barabuli]

Cant sort whole table by one column cause I need several different reports and everyone should be sorted differently.

I need sorting tool with certain report not the whole dataset

[v-sihou-msft]

@barabuli

There's no sorting tool on report level. You can sort categories on chart level.

Otherwise, the sorting is always on dataset level.

Regards, 

[barabuli]

Yes, Agree.

But my point was, why does chart Level sorting sort data irrelevant?

when I sort by certain Column, in my case by period ranges, sorting starts with letters, but not by alphabet, and then continues by numbers but not by acsending.

Why does it do in this way? Or what is the logic behind the sorting by certain column on chart level?

[Anonymous]

Hi @barabuli

I think it's because your horizontal axis is text and is sorted by ascending. That would certainly explain why you get the order, which you get. Let me know if this clarifies anything. I can also elaborate.

Best

Martin

[barabuli]

Thanks Martin,

but see, you cant choose it is by acsending or what? It just says "sort by "Column name"".

Agree that I have tex column, but in this case it should sort by alphabet.

I also tried to put numbers in front of every range, so it should by like:

1) less then 30 days

2) from 30 to 60 days

3) . . . .

but anyways it didn't sort by acsending numbers ((\

I understand that it is not number format, but text, but anyways there should be some logic either alphabet, or number acsending. I cant get any of them 😞

[Anonymous · Accepted solution]

When you sort by ascending on a text column it shows numbers first. And it only sorts by the first element of some text.

An example:

data = beer, 3, 10, 2, axe, cloth.

Sort data by ascending: 10, 2, 3, axe, beer, cloth

Sort data by descening: cloth, beer, axe, 3, 2, 1

These are the possibilities you have when sorting text. but there is a work around for this.

You can make a new column next to your categories, which can be called SortOrder and simply assign 1, 2, 3, 4, 5 and so on, and then sort by the column, either ascending or descending according to your need. 

Let me know if this will solve your challenge. I'll gladly elaborate.

Best

Martin

[barabuli]

ok, I got it. I'll find some way.

Thanks Martin 😉

[Anonymous · Accepted solution]

@barabuli Could I ask you to accept a solution for this so other can benefit from it as well?

[WESTL]

If I insert a new column and I want "Planned" to read 1; "Feasibility" to read 2; "Design" to read 3 etc how would I do it...would it be an IF statement?

I am a new user