Powerbi maps bubble chart colour do not want pie chart

[kkjoy81]

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)

[amitchandak]

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

[kkjoy81]

@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

[amitchandak · 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