Sort by Another Column Error Message Doesn't Make Sense

[alwang]

Hi,

I have a simple table, that contains a "Review Status" column as text, and a conditional column "Status Sort" that is based on the value of "Review Status".   "Review Status"  has nulls, and when it is null, "Status Sort" is also null.

But when I want to sort "Review Status" by "Status Sort", it shows this message. Power BI is obviously wrong on this. The value dependence between these two columns is "one-to-one" for sure. Why Power BI shows this message?

Thanks

[Kaviraj11]

Ok, got it. Please submit your issues here. Issues - Microsoft Fabric Community

[Kaviraj11]

Hi,

Can you confirm that each review status is being assigned with one sort value in Status Sort?. The error states that there's more than one value assigned to one of the value in review status which is rightly so because you can't have more than one. Please confirm or share the sample.

[alwang]

Thanks for responding!

And I can confirm that there is absolutely one value in "Status Sort" for one value in "Review Status". That's why Power BI is wrong on this.

But problem is solved now, after I closed and re-opened this Power BI file. It seems this is a bug that needs to be fixde by Power BI.