Forum Discussion
How to make a map not sum/count values
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...
Write a measure and use that. MyMeasure = sum(myTableName[Relevant column])
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.
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
