Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Scatter plot - overlapping Data points

scatter.png

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 it shows only point P.04 where as it ignores I.01 which also lie on the same cordinate . Can anyone help me to resolve the issue ?

1 ACCEPTED SOLUTION

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,

f1.png

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”:

f2.png

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
pbicvsupport@microsoft.com

View solution in original post

8 REPLIES 8
karo
Post Patron
Post Patron

@v-evelk It seems that I am facing similar issue and I do not see don't sumarize option 😞 Any additional hints how to resolve the issue?

v-evelk
Employee
Employee

Hello,

 

Could you please send your report for analysis to pbicvsupport@microsoft.com ?

 

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous
Not applicable

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

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,

f1.png

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”:

f2.png

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
pbicvsupport@microsoft.com

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.

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?

Anonymous
Not applicable

Thanks a lot

The solution is perfectly working fine

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
pbicvsupport@microsoft.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.