Tooltip in Scatter Graph only showing one value

[nslack]

Hi! I'm new to PBI, so sorry if i'm not explaining this well. 

I've created a scatter graph with some simple data. Each line in the data is a user with two columns for a score of 1-10. Therefore, there are multiple users with the same scores. 

The scatter graph is bulking those with the same scores into one dot. But when i hover over the dot, it doesn't show me all of the users that make up that dot. 

I created a tooltip with a matrix visual in the hopes that it would show me all of the users. It doesn't. It just shows me one user and not necessarily one labeled on the chart. It obviously can't add all labels because some dots may be made up of 15 or more users. 

I've really badly put a couple of screenshots below:

Help! 

Natasha

[v-jingzhang]

Hi @nslack 

Could you provide some simple dummy data to show how the raw data looks like? Which columns are used in the fields of this Scatter chart (e.g. X Axis/Y Axis/Legend/...) ?

Regards,
Community Support Team _ Jing

[nslack]

Hi Jing!

I hope i'm replying in the correct place!

The first image is the raw data, the second image shows the fields in the scatter chart. 

I've played around with all fields and not seen any changes. 

[v-jingzhang · Accepted solution]

Hi @nslack 

Thank you for the reply. You could download the attachment to see the details.

I combine the Alignment and Influence to make an X-Y column to group them. And I add an X-Y group table based on the original table and create a relationship on X-Y columns. Then use the Alignment and Influence columns from the group table into the scatter chart. When I click on a dot, you will see its related holders in the table next to it. You can put this table in your custom tooltip page. 

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.