Show overlapping values in scatter chart

[juliausha]

Hi! 

I created a view in scatter chart but the values that are overlapping in X and Y are hidden behind each other. Ideally, I would like the overlapping circles to have a different size or color that will be representing the volume behind it. If you could suggest another view or way around, that's also an option. 

That's what it's showing now, but X = 5 and Y = 4 should be looking different than the rest since it has more student names: 

My .pbix file: https://www.dropbox.com/s/58z7bkv3v8fse9d/My%20test.pbix?dl=0 

Thanks in advance fot your ideas!

[amitchandak]

@juliausha , As data is overlapping, I create a new measure and add a small rand()/10 number, and plotted

see if that can help

[juliausha]

Thank you for your reply @amitchandak ! Your solution indeed works great for a small sample as in my example. My actual case contains a sample of 8.5K people. When I use your solution, the volume is still not shown as I wish. It's still not clear where the biggest group is. In reality it would be X=1 and Y =1: