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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

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 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors