Bubble chart with different sizes

[PBI_newuser]

Hi, I have two sets of data which are Technician data and Installed Product data.

I want to create a similar chart as the screenshot below. Green bubble represents each serial number which has installed in the particular place (Zip Code). The larger bubble is to the number of technician in that area. How to create this chart in Power BI?

Technician data:

Technician	Zip Code	Country
Bob	35801	United States
Carol	90012	United States
Dennis	33190	United States
Elvis	60641	United States

Installed Product data:

Serial Number	Zip Code	Country
A123	49734	United States
B234	35816	United States
C345	44179	United States
D456	60633	United States

[v-xiaotang · Accepted solution]

Hi @PBI_newuser 

after I tested the default Map visual in Desktop, I find the size of Bubble can not be changed alone, it can only be changed together. as you can see in the picture bellow,

if you really need that function, I suggest you create an idea for it in
https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PBI_newuser]

Hi @v-xiaotang , could you please share me the pbix file for the screenshot you shared? Thank you in advance!

[v-xiaotang]

Hi @PBI_newuser 

I've attached the file bellow.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PBI_newuser]

Thanks you so much @v-xiaotang !

[v-xiaotang]

Hi @PBI_newuser

As far as I known, it seems that custom visual can achieve this effect. and I also will test whether this effect can be achieved by the default visual in BI desktop later.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.