Forum Discussion
How do I create this bubble chart?
I need help creating a bubble chart with the data set attach below.
I also attached a mock-up drawing of how I want the bubble chart to look like. I have tried different permutations but couldn't get a hang of it. I hope somebody can help me here. I am new to Power BI but I am very interested in learning it. I recognise the best way to learn it is to try it on data that I am interested in.
| Financial Institution Type | Category | Minimum paid-up share capital |
| COMMERCIAL BANKs | REGIONAL | 10,000,000,000 |
| COMMERCIAL BANKs | NATIONAL | 25,000,000,000 |
| COMMERCIAL BANKs | INTERNATIONAL | 50,000,000,000 |
| MERCHANT BANKs | NATIONAL | 15,000,000,000 |
| PRIMARY MORTGAGE BANKs | NATIONAL | 5,000,000,000 |
| PRIMARY MORTGAGE BANKs | REGIONAL | 2,500,000,000 |
| CREDIT BUREAUs | NATIONAL | 500,000,000 |
Thanks in advance
Mock-up drawing of what i want
Here is an example of what you can do with Charticulator. I just put your two categorical fiels on X and Y and assigned the dollar amt to the bubble size. I also added a measure to give the text formatted in Billions. Here is a video to help you get started with it.
(9) Season 1 - Charticulator - YouTube
Pat
Ajax I have created a custom visual for this problem. You can use this. Hope this solves your problem.
Snapshot of the visual:
Link for custom visual : https://drive.google.com/file/d/1-ex0TQWBNDyG8xG6hwi4RKo-tYAxRgos/view?usp=sharing
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
Ajax Changing the number format is not available from Power BI desktop. I have increased the decimal places to two as shown in the snapshot below. Whatever, the decimal places you will used during the visual creation will be fixed. I have uploaded the updated visual on the drive and shared the link below. Hope this helps.
For the PDF export, please try and extend the chart to the size of the page. Hope it will resolve the export issue.
Link: https://drive.google.com/file/d/11AH3IOCZotDWCfmh2BHc4EPm1jnXM_w9/view?usp=sharing
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
17 Replies
Here is an example of what you can do with Charticulator. I just put your two categorical fiels on X and Y and assigned the dollar amt to the bubble size. I also added a measure to give the text formatted in Billions. Here is a video to help you get started with it.
(9) Season 1 - Charticulator - YouTube
Pat
This is very close to what I want. So, can you send a screenshot of when you put each component of the data on the power BI analysis page? Also, I obverved that the "video" you gave a link to was actually a channel that contains many videos. please which of the video do i watch or could you just past the link to that video directly. Thanks
Also, which particular chart type did you use?
Sorry for the delay. Attached is the pbix file so you can see the visual, along with the measures I created.
Pat
You can probably do this using Charticulator
There is a sample in Templates which looks looks similar:
You can even download the template and sample data used to help you build it
Ajax Check the below snapshot, if this works for you.
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
Yes, this is what I want. But how do I do it on power BI? Actually, the data I have is huge. I only took a small sample for this question. I want to be able to create a power BI template for this type of visualization for this type of data going forward. So, can you send a screenshot of when you put each component of the data on the power BI analysis page?
Ajax I have created a custom visual for this problem. You can use this. Hope this solves your problem.
Snapshot of the visual:
Link for custom visual : https://drive.google.com/file/d/1-ex0TQWBNDyG8xG6hwi4RKo-tYAxRgos/view?usp=sharing
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
Also, it has to have 3 sections of "Regional", "National" and "International". It is very important.
Ajax Please find below the snapshot of the fields which I used to create this chart.
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
HelloAjax ,
As far as I understand, you are asking Y-axis to have multiple categories and though you are a new member, but your question is of advanced nature.
Power BI does not have this feature yet! (I might be wrong).
Please refer here:
https://community.powerbi.com/t5/Desktop/Multiple-Y-Axes/m-p/916383
You can vote here:
https://ideas.powerbi.com/ideas/idea/?ideaid=6efe0269-d94d-46b7-a6fb-c4c4df2be604
