Scatter chart overlapping points (i.e. multiple points with the same X and Y values)

[Anonymous]

Hi All,

I've hit a bit of a roadblock using the Scatter Chart within Power BI.  The issue is when multiple points have exactly the same X and Y values they are drawn on top of each other, but as the user of the report you are only able to see the last one that is drawn.

In this case I am using a scatter chart to display a cohort of students with their achievement (x-axis) and effort (y-axis) plotted.  The user of the report selects a student which is highlighted on the scatter chart in a different colour.  This works fine as long as there are no overlapping points, but in the case of a large cohort it is not uncommon for multiple students to overlap, and unfortunately the selected student can be obscured and no point is "highlighted" to the user.

There doesn't appear to be any way to set the z-order of points on the chart using a rule, or to dynamically order the students in this case, so that the selected student is drawn last.

I'm guessing others must have encountered this problem.  Are there any workarounds or solutions that I have missed?  I've also looked at 3rd party options, but in every case the controls are just too limited or don't function correctly in the first place.

Thanks,

Dave

Example #1: Multiple points overlap (Students A & B)

Example #2: Single point is highlighted correctly

[karo]

@newpi @v-xicai I am facing similar issue. 

I do not see don't summarize option, when I use measures on X and Y axeses.  Even if I change measueres to fields and follow the steps, I am getting an error:

Error Message:
Remove Values to display x- and y-axis pairs. Alternatively, you can keep Values and set a summarization for x- and y-axis.

Any hints? 

Regards,

Karo

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may follow steps below.

1.Set field Achievement (x-axis) and Effort (y-axis) Default Summarization: Don't summarize .

2.Create a measure like DAX below, and put it into Size box of the Scatter visual.

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

3. Select on this Scatter visual, go to Format pane, turn on the option "Category".

Best Regards,

Amy 

Community Support Team _ Amy

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

[newpi]

hi @v-xicai 

I;m facing the same issue. I can't see dont summarize option on my x and y axis probably because both these values are measures for me. What would be the best work around?