Power BI Desktop April 2024 : Sort by issue. False duplicate alert

[dpFr33]

Hi,

I have one calendar table (french).
12 month : Janvier, Février... Décembre 
An integer column [1..12] : 12 values
janvier = 1
février = 2...
etc.

All was working fine and I never had any "duplicate value ..." error message when trying to Sort a column by another one.

Version :  2.128.952.0 64-bit (avril 2024)

Regards,
Denis

[Anonymous]

HI @dpFr33 

How did you set up the sort? Please provide a screenshot of your setup. 

Best Regards,
Community Support Team _ Ailsa Tao

[IvaD]

I am having the same problem, and it is also new for this month. I have a project table with one column called "Status", and a status order table to sort these status labels in my visuals.

StatusLabelOrderTable

StatusLabel	Order
Yes	1
Maybe	2
No	3
Unreviewed	4

ProjectTable

Project	Status	StatusOrder
ABC	Yes	1
DEF	No	3
HIJ	Unreviewed	4
KL	Maybe	2
NOP	Yes	1

Before, I would add a calculated column StatusOrder = Related(StatusLabelOrderTable[Order]) and sort Status by StatusOrder, but now it says this: 

I filtered by each status label and status order value to confirm there were no cases of anything other than a 1:1 relationship between the status and status order, and there aren't.

Interestingly, I can sort StatusOrder by Status, just not the other way around.

[tjess]

I am seeing the same issue with the new release. Columns that I was previously able to sort by another column, are no longer able to do so within Desktop. I am able to still assign the sort by column using Tabular Editor, but the desktop version doesn't allow this anymore.

[jasonn]

Same - Sort accepted in March release but not in April release... Grrr....