topic Re: Tooltip not displaying correct values in scatter chart in Desktop

Tooltip not displaying correct values in scatter chart

SBCSSdata — Tue, 07 Sep 2021 19:14:15 GMT

I have a table with data for student groups and districts. In the scatter chart it displays a dot based on the district and size of student group. I have one group that is not displaying properly and the tool tip is showing data from a different record. The example looks like this:

District A,Student Group X,math,11514,93.9,3

District B,Student Group X,math,2226,93.9,3

Because the x asis is the same (93.9) and the y axis is the same the dots should overlap, but only dot is being displayed. Other districts overlap show both dots and tooltips properly.

The bigest issue is that on mouseover it displays District A with 2226, not 11514 (the value for that record)

It works fine with other disticts and student groups. All filters are set to all. Everything else displays properly.

Any Ideas? Thanks in Advance

Re: Tooltip not displaying correct values in scatter chart

amitchandak — Wed, 08 Sep 2021 06:07:34 GMT

SBCSSdata , Can you share the same data in the table visual to check if the values

Re: Tooltip not displaying correct values in scatter chart

SBCSSdata — Thu, 09 Sep 2021 23:02:24 GMT

The data in the table was accurate. The issue was that the values of the x axis and y axis were the same for the student group. It should have displayed both dots, but didn't. Changing the data in the table for one of the districts by decreasing it by one onehundredth allowed it to display properly, something that Microsoft needs to be aware of. THANKS for replying.

Re: Tooltip not displaying correct values in scatter chart

v-easonf-msft — Fri, 10 Sep 2021 02:50:43 GMT

Hi, SBCSSdata

For your requirement , you can submit it as an idea on Power BI Ideas forum and add your comments to improve this feature.

Best Regards,
Community Support Team _ Eason

Re: Tooltip not displaying correct values in scatter chart

SBCSSdata — Fri, 10 Sep 2021 20:31:52 GMT

THANKS v-easonf-msft I just submitted it.

Re: Tooltip not displaying correct values in scatter chart

SBCSSdata — Fri, 10 Sep 2021 20:47:47 GMT

UPDATE: The only solution I could find was to change one of the values in the spreadsheet (I changed one district from 93.9 to 93.8) and refreshed. This created enough difference for both display a tooltip for each properly AND each with its own dot (see below).