Scatter chart has overlapping values which get hidden

[newpi]

Hi I have a scatter chart with measures on the X & Y Axis 
X Axis measure is days completed

Y Axis measure is No. of users

Details field has Student name

Size field also I'm using no. of users. measure

The detials field has user name . There are some users that have same X & Y Coordinates. So one gets hidden behind the other. I searched the community and one of the ways to solve this is using the following measure in size field on the scatter chart. 

Size Measure = IF(ISFILTERED(Table1[Student]),COUNTROWS(Table1),CALCULATE(COUNTROWS(Table1),ALL(Table1[Student])))

But this doesn't solve completely. Like if 3 or more students have the same X & Y coordinates, then not all lables are visible and only 2 are visible on the same coordinates. And if possible I would want to use the size field for no. of users and not the above size measure but I can compromise here if could separate out the bubbles (make them visible) on same coordinates . 

Alternatively, I'm open to using a better visual for this if scatter plot doesn't solve it. All I need is to show 

days completed since signup (measure)

No. of users (measure)

Student name . (column value)

These values need to be clearly visible and I have around 20 distinct points in each chart.

[v-yingjl]

Hi @newpi ,

You can create a calculated column to replace [Days since signup] measure to use it as x-axis and try to use a custom visual 'Dot plot by MAQ software'

Datediff = DATEDIFF('Sheet1'[signup date],TODAY(),DAY)

See the modified sample file in the below, hopes to help you.

Best Regards,
Yingjie Li

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

[newpi]

@v-yingjl Thanks for reaching out. Its a little more complicated. Instead of signup its actually sign in and a user can have multiple rows of signin date and thus I then need to take the last signin date. But unable to figure out how to do it here. 

[amitchandak]

@newpi , Try to increase transparency, reduce the size . or put student or student id as legend

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

or add some very small random value to x and Y

[FarhanAhmed]

Go to Format Tab

Under format expand Shape

-> Change the Size of the marker to adjust it accordingly, hopefully you will be able to get all the labels that get hidden or overlapped.

[newpi]

Thanks @FarhanAhmed 
Adjusting the size helps when I have 2 overlapping bubbles but it still does not solve the problem for 3 or more Bubbles overlapping on same coordinates . If I have 3 or more, then it shows me their value in the plot but I cannot hover over all 3 individually and see tool tips created for them on a tool tip page.

[FarhanAhmed]

Can you please share some sample data that is overlapping in the Scatter Plot ?

[newpi]

@FarhanAhmed  Attached is smaple pbix file.

You see U1, U2, U3 are on same coordinates but when I click that bubble only U3 gets selected on the top .

I want a way to show all point that are on same coordinates and also select all in the top table

Weird, I cant seem to attach the file. There is no option herehttps://drive.google.com/file/d/1oSqT3SKsZSlwIpfNFktMH2WRaiIa8H1d/view?usp=sharing