Scatter chart, duplicate values. How to show them?

[dgeglawy]

Hello,

I have a scatter chart which holds coordinates X and Y, on it i have unique items with their own ID's i'd like to show. However, if two different items have the same X and Y it only shows one of them. Is there any way to avoid this problem and show both of the items?

Screenshot of the chart and its table:

https://gyazo.com/2ba0d1a5713223513d54fe13528720fa

Thank you in advance

[Anonymous]

It's best to use color saturation for showing density of points. The density would be correlated with the number of points at the location of interest.

Also, in R there are plots that add random jitter to points that are at the same location. I don't think this is available in PBI visuals but you could use R or Python to create such jittering plots.

Best
D

[Greg_Deckler]

So like one on top of the other but smaller or like the circle split down the middle or?

[dgeglawy]

A split circle would be great if it'd still split it in case of there being more(5,6....) of the same values.

[mahoneypat]

How about using size or doing expression based formatting, using count of rows with same X and Y value?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[dgeglawy]

I tried out the size option and it seems to fix the problem and actually add some nice functionality. Thanks a lot and sorry for the problem.