Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
charmer23
New Member

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 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!

4 REPLIES 4
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MattAllington
Community Champion
Community Champion

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

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.

1.PNG

 

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

2.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.