Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Error ordering Sizes

I have a table that I want to represent in an orderly way according to the Size, but different sizes can be registered and I get the error "You can not sort by the column "Letter" "by Ntalla". You ca...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Syndicate_Admin ,

     

    According to your statement, I think you want to sort [TallaO] column by [OrdenTalla]. However, I find there are multiple duplicates sort numbers in [OrdenTalla] for different [TallaO].

    For example:

    TallaO = 10, OrdenTalla = 8

    TallaO = 3x, OrdenTalla = 8

    This will make Power BI confused which one should be sorted in 8.

    So you will get error when you sort [TallaO] column by [OrdenTalla]. I can reproduce your issue in my test.

    I find that there are multiple sort number when TallaO equal to S. 

    TallaO = S, OrdenTalla = 1

    TallaO = S, OrdenTalla = 2

    This will casue error as well. Due to this situation, we can not add another new sort to achieve your goal.

    So I suggest you to add [OrdenTalla] in Matrix column field in top level.

     

    Best Regards,
    Rico Zhou

     

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

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Syndicate_Admin , Create a new column like this and use that as sort column

 



new OrdenTalla =
if( not [OrdenTalla] in {"S", "XS", "M", "L", "XL", "1X", "2X", "3X", [new OrdenTalla] + 20)

 

Modify as per need

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Graccias me sale el error Column 'new OrdenTalla' cannot be found or may not be used in this expression.

    I understand that if the Size number is not in the matrix it should be increased or create a larger number?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Syndicate_Admin ,

       

      According to your statement, I think you want to sort [TallaO] column by [OrdenTalla]. However, I find there are multiple duplicates sort numbers in [OrdenTalla] for different [TallaO].

      For example:

      TallaO = 10, OrdenTalla = 8

      TallaO = 3x, OrdenTalla = 8

      This will make Power BI confused which one should be sorted in 8.

      So you will get error when you sort [TallaO] column by [OrdenTalla]. I can reproduce your issue in my test.

      I find that there are multiple sort number when TallaO equal to S. 

      TallaO = S, OrdenTalla = 1

      TallaO = S, OrdenTalla = 2

      This will casue error as well. Due to this situation, we can not add another new sort to achieve your goal.

      So I suggest you to add [OrdenTalla] in Matrix column field in top level.

       

      Best Regards,
      Rico Zhou

       

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