Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
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
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
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |