Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Scatter plot - overlapping Data points

I have created a scatter plot with point having the same cordinates, but when i click on any of the points it shows data  for only one point , it ignores the other overlapping points. Example i...
  • v-evelk's avatar
    v-evelk
    6 years ago

    Hello,

     

    Please, try the following steps:

     

    "The scatter dots are rendered sequentially, and in this case since they are perfectly stacked so only one gets the click event. For points like this,

    if the user wants a single click to select all 5, they need a scatter chart that has a composite group on X and Y. Remove Reference from Details, then update aggregation for X and Y to be “Don’t summarize”:

    Place this visual exactly on top of the first. Then open the selection pane and ensure the X/Y grouped visual is higher in Z Order so it gets the clicks. The chart underneath will only be used for category labels. Also, increasing the size of the dots makes them more clickable."

     

    Kind Regards,

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

v-evelk's avatar
v-evelk
Microsoft Employee
7 years ago

Hello,

 

Could you please send your report for analysis to [email protected] ?

 

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have mailed a test .pbix with the same issue  . could you look into it to solve it . Thanks in advance 

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    6 years ago

    Hello,

     

    Please, try the following steps:

     

    "The scatter dots are rendered sequentially, and in this case since they are perfectly stacked so only one gets the click event. For points like this,

    if the user wants a single click to select all 5, they need a scatter chart that has a composite group on X and Y. Remove Reference from Details, then update aggregation for X and Y to be “Don’t summarize”:

    Place this visual exactly on top of the first. Then open the selection pane and ensure the X/Y grouped visual is higher in Z Order so it gets the clicks. The chart underneath will only be used for category labels. Also, increasing the size of the dots makes them more clickable."

     

    Kind Regards,

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks a lot

      The solution is perfectly working fine

    • juan_pablo's avatar
      juan_pablo
      Helper V
      6 years ago

      Hi v-evelk

      How can I change the order in which the dots are staked when I have a legend? In the same coordinates I have three points that overlap but each correspond to a different category, how can I change which category goes on top?

    • newpi's avatar
      newpi
      Helper V
      5 years ago

      Hi v-evelk I'm seeing the same issue and I don't see an option to say don't summarize in my drop down.

       

      I have a measure called 'Days' on x axis & '# of Users' on Y Axis.

       

      The details section has application name in it.

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    6 years ago

    Hello,

     

    Thanks a lot, I've received it.

    I transferred details to an appropriate team so, as soon as I get an answer I will provide info here.

     

    Kind Regards,

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]