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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Advocate V
Advocate V

@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
Microsoft Employee
Microsoft 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors