cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kkjoy81
Regular Visitor

Powerbi maps bubble chart colour do not want pie chart

Hi,

I have noticed similar questions online but no solid answers regarding bubbles displayed on maps.

I have the following table columns: ‘Latitude,’ ‘longitude,’ uniqueID… I have a table connected to this with the following columns ‘country,’ ‘subregion ‘, ‘uniqueID’ (which connects it), production amount.

I want to colour by ‘subregion’ (so all projects in Australia have the same colour etc), but it seems to break it all out into piecharts… which I don’t want. It also does not show every location but seems to assign a big bubble across these areas…

I currently use Arcgis and also Microsoft maps. I crossed out 'production' column below.

 

When i take off what is in the legend, all the bubble sizes are the same (it seems to be calculated  the whole column) and showing this as the same value too?

Would love recommendations, thanks (i'm also fairly new with the maps function of powerbi)

 

 

kkjoy81_1-1656989844198.png

 

kkjoy81_2-1656989844201.png

 

1 ACCEPTED SOLUTION

@kkjoy81 , In the size of the bubble and color you should be able to use measure. It will not work when you are using legend. as legend will create its own color



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@kkjoy81 , Usually conditional formatting does not work if you use legend or more than one measures



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

@amitchandak Thanks for the message... It turns out what i am displaying is a measure... bummer. Is there anyway around this? With only displaying lat and long and this column of data, the size of the bubble is the same across the entire map now. Is there anyway to modify it so it shows differences in size based on value

@kkjoy81 , In the size of the bubble and color you should be able to use measure. It will not work when you are using legend. as legend will create its own color



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors