Forum Discussion

Ajax's avatar
Ajax
Frequent Visitor
4 years ago
Solved

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 ge...
  • mahoneypat's avatar
    4 years ago

    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

  • ghoshabhijeet's avatar
    4 years ago

    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 👍

  • ghoshabhijeet's avatar
    4 years ago

    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 👍