Power Bi does not order with custom column

[cherryguille]

Hi,

I am having a littel bug with my table and maybe someone can help me. I have one little table of 10 rows with two a few columns. I have created a new custom column that sum two whole numbers.

After, i created a table with an id and the new field. 

Here comes the problem, after created the table I sort the table with the new field and the row that should be the first is on the middle of the table.

I do no understand that, because is a simple table with a sum of two whole numbers and no more.

Maybe someone know something about this kind of bug/mistake?

Keen regards,

William

[Gazzer · Accepted solution]

That looks like it is sorting alphabetically, rather than numerically.

Check that the field is actually a number and not text.

The fact that the numbers are left aligned and not right aligned would seem to back this up.

[v-haibl-msft · Accepted solution]

@cherryguille

Please change type of the custom column as Gazzer said.

Best Regards,
Herbert

[cherryguille]

Good morning @v-haibl-msft , @Gazzer, that was the problem. The new costum column it is not whole number, i change the format and it already work, thank you both.

[Gazzer · Accepted solution]

That looks like it is sorting alphabetically, rather than numerically.

Check that the field is actually a number and not text.

The fact that the numbers are left aligned and not right aligned would seem to back this up.