Forum Discussion

SBCSSdata's avatar
SBCSSdata
Regular Visitor
5 years ago
Solved

Tooltip not displaying correct values in scatter chart

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

 

  • 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).

     

5 Replies

  • SBCSSdata's avatar
    SBCSSdata
    Regular Visitor

    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.

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support

      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

       

    • SBCSSdata's avatar
      SBCSSdata
      Regular Visitor

      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).