Forum Discussion

AdamMG's avatar
AdamMG
Helper I
2 years ago

Measures - values sorted ASC

Hi everyone. Basically I need to create a scatter plot where I will have x and y sorted ascending and plot against each other, ... so the number are not correlated to each other anymore My table ...
Need Help
AdamMG's avatar
AdamMG
Helper I
2 years ago

Hi Anonymous 
I know how to create scatterplot in vega....
I don;t know how to create the measures ... 😉

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AdamMG ,

     

    Do you mean an ordering measures of x and y?

    Rank_X = RANKX(ALLSELECTED('Table'),[x],MAX('Table'[x]),ASC,Dense) 
    Rank_Y = RANKX(ALLSELECTED('Table'),[y],MAX('Table'[y]),ASC,Dense)

    Best Regards,

    Neeko Tang

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

    • AdamMG's avatar
      AdamMG
      Helper I
      2 years ago

      Hi Anonymous 
      Not really....
      Please take first table and try to create second chart.