Forum Discussion
Sort by Another Column Error Message Doesn't Make Sense
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 ...
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.
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.