We cannot sort the 'A' column by 'B'. You cant have more than ...

[lmpb1988]

Hello

I have a table with two columns - age and index and in this table I have several ages that each correspond to a letter, and I do not have repeated values ​​in either column or the other.

Then I have another table where I again have columns with age and sorted age, and the sorted age table shows the correct letters.

I also have a relationship between the two tables, namely between the age columns.

However, when in the main table I sort the age column by the sorted age column it gives me the error "We cannot sort the 'A' column by 'B'. You can't have more than ..."

Can someone help me?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Please ensure that the column titles are in English.  Also, remove the tables/columns which are not relevant to this problem.

[v-yajiewan-msft]

Hi @lmpb1988,
Please check if there are null/blank values in the data, and if so, delete them.

Currently, the blank value will cause this issue, and it has been submitted internally.

Please be patient to wait for fixing. If there is any news, I will update it here.

Similar issue:
Sort by another column error - Microsoft Fabric Community

Best regards,

Joyce

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

[lmpb1988]

Anyone?