Scatter plot, bubble size dependent on amount of bubbles

[MaxSchrijen23]

Hi Guys,

At the moment I have created a bubble chart that shows how risky a project is on two scales. On the red-marked bubble I have at the moment projects laying on top of each other, is there a possibility to let the size of the bubble depend on the amount of single values at that exact point? So, it should be some kind of count which counts the project having the same values for the X and Y-axis. 

Kind regards

[v-chenwuz-msft · Accepted solution]

Hi @MaxSchrijen23 ,

Yes, you can try some measure like this:

Countrow(filter( 'project table') , [value1] = selectedvalue('table'[x]) && [value2] = selectedvalue('table'[y])))

If you need more help, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

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