Forum Discussion
How to make a bubble chart
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!
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
3 Replies
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 BIThank 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?
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