Bubble Size of Scatter

[DW868990]

Hi,

I have a scatter chart which has multiple data points on, now i have many data points in the exact same location, so the data points are sat on top of each other.

I am looking for a measure that controls the bubble size via count of locations in that data point, so the more points in the same location, the bigger the bubble.

Is this possible?

Thanks in advance.

JJ

[DW868990]

Thank you! Works great

[v-yadongf-msft · Accepted solution]

Hi @DW868990 ,

This is my test table:

Create a new column to count the number of duplicate values for each ID.

Size = CALCULATE(COUNT('Table'[Value]),FILTER('Table','Table'[Value]= EARLIER('Table'[Value]) && 'Table'[ID] = EARLIER('Table'[ID])))

Is this the result you want?

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.