Forum Discussion
Helper VScatter chart has overlapping values which get hidden
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.
7 Replies
- amitchandak
Super User
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
FarhanAhmedCommunity Champion
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.
newpiThanks 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 ?
v-yingjlCommunity Support
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
