Forum Discussion
Helper IIIScatter plot- add legend removes the X axis ordering
Helper IIIHello v-yalanwu-msft,
Thank you for your help, but it did not work because I have more than one Client per Product.
I tried with my data and I got this message: It's not possible to sort the column "ClientID" by "sort". It cannot exist more than one value in "sort" for the same value in "ClientID". Choose a different column to sort or update the data in "sort".
Community SupportHi, valcat27 ;
According to your description, I tested it which one product have three different client . then use same ways sort ,and it is ok.
The final output is shown below:
I am sorry that i can't reproduce your error, however , you also could try to create a index column as a sort column in power query .
1.sort by ProductID
2.Add index column as a sort column.
3.sort by index column.
If it doesn't work, can you share the picture of your data or pbix whitout any sesentive information and the result you want to output?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- valcat27
Hello v-yalanwu-msft ,
Thank you again for your help.
Creating the index column, I got the same message error. I am sorry, but I noticed that I misinterpreted it. The problem is that the same ClientID can have more than one product. So when I choose to sort ClientID column by sort/index column, that client will have more than one value associated and probably the program will not know which value to choose to apply the sorting.
- v-yalanwu-msft
Hi, valcat27 ;
Sorry, it is difficult to reproduce your mistake, can you share your file whitout any sensitive information?
- valcat27
Hello v-yalanwu-msft ,
The error message is the same. I created a new table (Table2) with duplicated clients in your pbix. I think that if you try to sort ClientID column by sort/index column, you will get the message that I referred.
I'm not able to attach the pbix. I tried to paste it and I got the error: "The file type (.pbix) is not supported."
This is the table with my changes:
ProductID Price ClientID 12244 13 f 12334 53 f 12345 16 ce 12345 17 be 12345 8 ce 13234 12 a 13445 45 sd 13455 21 dw 45566 13 a