Forum Discussion
Scatter chart overlaps and hides values
I'm trying to make some scatter charts but I have an issue where some of my categories have exactly the same data, resulting in one of them being hidden behind the other.
I have tried making a measure for size and enabling categories (saw this tip in another thread), this shows me the "missing" name but is gets confusing for users since the name is in the wrong place so to speak. Would be better if it was next to the one that is showing correctly. Or some other indicator that there is multiple values/categories on a certain point. So when you hover mouse over you can see that there are more categories there.
Any suggestions on how to achieve this?
Hi Anonymous
I found two similar issues in the community, maybe you can refer to them to see if it is feasible.
https://community.powerbi.com/t5/Desktop/Scatter-chart-duplicate-values-How-to-show-them/m-p/1090174
https://community.powerbi.com/t5/Desktop/Scatter-Chart-Bubble-Size/m-p/1706419
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- amitchandak
Super User
Anonymous , Switch on color by Category , Switch off fill point and check does it make any diff
Hi Anonymous
Could you provide your data (hiding sensitive information) in detail and the effect of your initial attempt ?
It may help us to deal with the problem better .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thanks for the reply,
Ofc, here is the data, screenshots below.
Category A Category B Y value X value A B1 3,0 3,0 A B2 3,0 3,0 A B3 3,0 3,0 A B4 3,0 3,0 A B5 3,0 3,0 A B6 3,0 3,0 A B7 3,0 3,0 A B8 3,0 3,0 A B9 3,0 3,0 A B10 3,0 3,0 B B1 3,0 3,0 B B2 3,0 3,0 B B3 3,0 3,0 B B4 3,0 3,0 B B5 3,0 3,0 B B6 3,0 3,0 B B7 3,0 3,0 B B8 3,0 3,0 B B9 3,0 3,0 B B10 3,0 3,0 C B1 1,0 1,0 C B2 4,0 5,0 C B3 1,0 1,0 C B4 1,0 1,0 C B5 1,0 1,0 C B6 1,0 1,0 C B7 1,0 1,0 C B8 3,2 5,0 C B9 1,0 1,0 C B10 1,2 4,0 D B1 0,0 0,0 D B2 1,0 4,0 D B3 0,0 0,0 D B4 4,0 5,0 D B5 1,0 3,0 D B6 0,0 0,0 D B7 4,0 5,0 D B8 3,0 5,0 D B9 1,0 4,0 D B10 1,0 4,0 E B1 1,0 2,0 E B2 2,0 4,0 E B3 3,0 5,0 E B4 3,0 5,0 E B5 2,0 3,0 E B6 4,0 5,0 E B7 4,0 5,0 E B8 1,0 2,0 E B9 2,0 3,0 E B10 2,0 5,0 F B1 4,0 4,0 F B2 1,0 1,0 F B3 1,0 1,0 F B4 2,0 3,0 F B5 2,0 3,0 F B6 1,0 2,0 F B7 2,0 2,0 F B8 1,0 2,0 F B9 4,0 5,0 F B10 1,0 1,0 G B1 4,0 5,0 G B2 3,0 5,0 G B3 4,0 5,0 G B4 3,0 5,0 G B5 2,0 3,0 G B6 4,0 4,0 G B7 3,0 5,0 G B8 3,0 5,0 G B9 4,0 4,0 G B10 3,0 5,0 Result with filter for Category B - B4.
We can see that A is "hidden" behind B. Same with E being hidden behind G.
Hi Anonymous
I found two similar issues in the community, maybe you can refer to them to see if it is feasible.
https://community.powerbi.com/t5/Desktop/Scatter-chart-duplicate-values-How-to-show-them/m-p/1090174
https://community.powerbi.com/t5/Desktop/Scatter-Chart-Bubble-Size/m-p/1706419
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am having the same trouble. I am using a bubble size to show the number of data points with the x,y values but I can't seem to figure out how to allow the user to pick which of the points they would like to drill through to. Right now, it only allows the user to pick ONE item to drill through.
