Forum Discussion
Power Bi does not order with custom column
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
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.
3 Replies
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.
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.