How to make a bubble chart

[Anonymous]

Hello,

I am trying to make a bubble chart but can't get it the way I want it. I have the following data in a table: a person's name, a person's score , a person's attitude and a person's potential score. All these data are expressed as a percentage. Here are some examples of the data:

Name	Score	Attitude	Potential Score
John Johnson	70%	60%	80%
Chris Paul	80%	70%	80%
Adam Brooks	60%	60%	60%

In my bubble chart, I would like the score on the Y-axis, the attitude on the X-axis and the potential score as the size of the bubble.

When I place these three fields in the appropriate column of my visual, I don't see 1 bubble per person but just a number of bubbles with a combination score - attitude. In addition, for the size of the bubble I can only choose between sum / average / ... of the potential score but not the potential score belonging to the person.

Any idea which settings I should use correctly for my visual?

Thanks! 

[Shaurya]

Hi @Anonymous,

Plot a scatter with these fields:

Result:

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

[Anonymous]

Thank you @Shaurya , I now get to see a bubble for each person but each bubble is still the same size, namely 220 (80+80+60). How could I fix that the bubble shows the exact potential score for the person? 

[Shaurya · Accepted solution]

Hi @Anonymous,

Use the fields as shown in the image in my original reply. You should see the size of the bubble corresponding to potential score.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI