Forum Discussion

alwang's avatar
alwang
Frequent Visitor
1 year ago

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 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

 

Need Help

3 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    1 year ago

    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's avatar
      alwang
      Frequent Visitor
      1 year ago

      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.