Forum Discussion
valcat27
Helper III
5 years agoScatter plot- add legend removes the X axis ordering
Hello all, I created a scatter plot that is defined to be sorted by x-axis, but when I add the legend, it is no longer ordered correctly. For a better understanding, imagine that I want to o...
v-yalanwu-msft
Community Support
5 years agoHi, valcat27 ;
Sorry, it is difficult to reproduce your mistake, can you share your file whitout any sensitive information?
valcat27
Helper III
5 years agoHello 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 |