Forum Discussion

valcat27's avatar
valcat27
Icon for Helper III rankHelper III
5 years ago

Scatter 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...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, valcat27 ;

You could create a column by dax or create a index column in power query as a  auxiliary sorting column. as follows:

1.create a sort column.

sort = RANKX('Table',[ProductID],,ASC,Dense)

2.Select the name field, and then sort by sort column.

3.The final output is shown below: 

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's avatar
    valcat27
    Icon for Helper III rankHelper III
    5 years ago

    Hello 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". 

    • v-yalanwu-msft's avatar
      v-yalanwu-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, 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's avatar
        valcat27
        Icon for Helper III rankHelper III
        5 years ago

        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.