Forum Discussion
Size field in the map visual
- 6 years ago
Do you already have a column that indicates if that row is a City or Village? If not, you can generate a Groups column to do that easily. See this link on how to do that - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
Once you have that, you can use a measure that returns a size for each city depending on if it is a City or Village. For example, you could have one like
Bubble Size = IF(MIN(Date[LocationType]) = "City", 10, 5)
This assumes your new column is called LocationType. You can put that measure in the Size field. You'll have to play with the 10 and 5 values to get what you want.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
add a new calculated column that holds the desired size based on your criteriae. Then pull that column into the size bucket.
Anonymous I liked mahoneypat solution assuming you have a column to identify city and village.