How to make a map not sum/count values

[charmer23]

I am creating a map and have each bubble representing a projects in a particular state using lat/long. I would like the size of the bubble to corrilate to the size of the project and the color or the bubble be gradient based on the price. I am unable to create this because it automatically sums or counts the price and size. I have turned off default summarization in the modeling tab and that did not help. Please help!

[v-yulgu-msft]

Hi @charmer23,

Have you worked it out? If so, would you please kindly mark the corresponding reply as an answer so that it can help more people having similar concern? If you still have any concern, please feel free to ask.

Regards,
Yuliana Gu

[MattAllington]

Write a measure and use that. MyMeasure = sum(myTableName[Relevant column])

[charmer23]

I don't want it to sum or count the data. For example on the map I would like the color of the bubble to show whether it is a wind or solar project, however when I drop technology type into the color box it does count of technology. I just want a yellow bubble if it is solar and blue if it is wind. 

[v-yulgu-msft]

Hi @charmer23,

Adding field into color saturation section of a map visual will set the bubble color to gradient. It won't paint the bubble with different colors.

To work around your requirement, you can change the bubble color manually under Format pane.

Alternatively, you can drag the color field into legend section.

Best regards,
Yuliana Gu