Scatterplot

[gill_thornton]

Good morning

I am fairly new to Power BI and work in a school setting and have now successfully set up for our pastoral/attendance side of things.  I have now turned my attention to assessment and exams which covers DfE headline figures and again mainly successful.  However, a standard practice is to set up scatter plots in quadrants looking at relationships, amongst other things, effort grades versus progress scores.  The problem I have is that some of our students have the same progress/effort as several other students, but when I add detail, the scatter plot only picks up one of these students, and when I click on the data point on the scatterplot only filters on one of the students and not all students on that particular point.  Can anyone help with a way around this please?

[amitchandak]

@gill_thornton , You can create drill though where you do pass the student id( You can control that by disabling "Keep all filter") on drill through the page.

You can select multiple using ctrl +click

Or enable this option and use Ctrl or Shift + drag-select

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-multi-select#select-multiple-elemen...

[gill_thornton]

Thank you for your reply.  However, this isn't quite what I need.  There are several students sitting behind one data point on the scatterplot but when I hover over the point only one student's name appears and when I click on the data point it filters to just one student instead of all students involved.