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.

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

thank you I understood what the problem was.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Syndicate_Admin ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file without sensitive data.


Best Regards,

Rico Zhou