cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD61 Member
Member

Power BI Map formatting

Hello, 

 

In my data base  I have a field Country-City and a field Cost.

How to organize these fields so that the diameter of each circle will be proportional to the Cost implied in the city?

 

Thanks

Map Country City.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Sean Super Contributor
Super Contributor

Re: Power BI Map formatting

Well are the Cost numbers all the same for the 4 cities? Then this would happen. Smiley Happy

View solution in original post

5 REPLIES 5
Sean Super Contributor
Super Contributor

Re: Power BI Map formatting

Have you tried placing Cost in the Size field?

 

Map - Size & Legend.gif

GD61 Member
Member

Re: Power BI Map formatting

Hi Sean,

Yes, I put the Cost in the Size area, but the diameters did not change. I checked that the values of Cost are numbers.

Any idea?

Sean Super Contributor
Super Contributor

Re: Power BI Map formatting

Well are the Cost numbers all the same for the 4 cities? Then this would happen. Smiley Happy

View solution in original post

Highlighted
GD61 Member
Member

Re: Power BI Map formatting

Yes, you are right : the value for the 4 cities are quite similar !

But some others cites which have value, doesn't appear at all. I have to dig that

 

Thanks a lot !

Sean Super Contributor
Super Contributor

Re: Power BI Map formatting

You can also try adjusting the Bubble Size setting

 

Bubble Size.gif

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 176 members 1,717 guests
Please welcome our newest community members: