Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
beingEniola
Regular Visitor

Scatter plot Visual error

I want the bubbles to be labeled by countries names, I tried doing that by adding the country columns to the variables but it returns an error. It says "remove values to return x and y axis pairs, alternatively you can keep values and set a summarization for x and y". What do I do, summarizing does not visualize what I want.
Screenshot 2024-09-19 153250.png

3 REPLIES 3
lbendlin
Super User
Super User

It will work , but it's not intuitive.  Choose a summarization that is not hurting the data.

 

Please provide sample data that fully covers your issue.

I tried summarizations but they hurt the data. Especially on the Y-axis, when I used the sum summarization on the X-axis and left the Y-axis unsummarized it did not affect the data (But I could not still add the country field into values, because both axes have to be summarized). other summarizations that I tried hurt the visual because it returned a clustered data point just one big bubble.

 

Total Medal,Population,GDP per capita
1,380356,73199
6,528192,33634
1,1840233,7370
2,2115228,29367
3,2816919,24969
18,2839144,6022
5,3204802,7653
1,3386015,4965
1,3794784,6484
3,3907027,18163
3,4589511,40213
44,5110016,103570
83,5131734,48177
450,5456801,106155
67,5473197,21097
254,5569299,50424
4,5649885,82619
109,5902904,66985
13,6791213,9351
68,7465915,48198
265,8792182,91866
498,9064677,52004
230,9103151,57346
56,9173237,7935
28,9684306,18462
5,10242086,49554
12,10295304,7646
7,10412480,21039
26,10417073,24186
410,10487338,55871
81,10673213,27257
2,11256263,4216
88,11641820,49700
77,12119334,3850
45,16069056,1287
2,17847877,5323
471,17904421,55356
1,20034609,11012
875,26200984,63945
3,34695493,11711
10,34938955,2301
1,37329064,3595
491,38385739,17928
917,38821259,55120
432,41048766,3910
5,44070551,5995
75,45407904,13935
4,45477389,4220
514,47828382,29219
274,51782512,32159
10,54252461,2091
339,59619115,33721
173,62378410,6507
857,66277409,41989
1407,68179315,45038
15,71735329,6905
1462,84086227,48429
12,87058473,10407
65,89524246,4340
2,99680655,4101
98,112618250,4233
262,124997578,33850
122,128613117,10996
434,145579899,15390
178,210306415,9130
51,223150896,2139
7,278830529,4731
2062,341534046,74554
941,1425179569,12604

I want the bubbles to be labeled by countries names

Missing from the sample data.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors