Forum Discussion
How do I create this bubble chart?
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 👍
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 👍
I can't download the file. could you please mail it to me at [email protected]. Thanks.
Ajax Please download it. Won't be able to mail. Thanks !
I have been able to download it and import it. very brilliant of you. Thank you. Just a little thing, How do i increase the decimal places of the numbers to like 3 decimal places? E.g. I have 35,000,000 which is simply showing as 0.0B instead of 0.035B. Also, how do i expand the size of the whole chart so that it fits well on an A4 paper? When i exported the chart to pdf, it only convered like 30% of the paper. I will like the chart to cover like 80% of the sheet. Please show me where to effect the necessary changes. Thank you
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 👍
Thanks is this visual link still available? can' see it
