The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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.