Year over Year Bubble map

[christyleebrink]

I'm trying to create a map of year over year values with a bubble map. I want last years values one color bubble and this years values a different color bubble. How do I accomplish this? Currently, when I click on last years and this years values, the bubbles take in the SUM of those values rather than plotting them distincly. 

Anyone know how this can be accomplished?

[fhill · Accepted solution]

By default, Scatter Charts (I"m assuming your bubble map) doesn't like dates on the X or Y axis.  This link helped me create your solution:

https://community.powerbi.com/t5/Desktop/Scatter-with-date-on-X-and-time-on-Y/m-p/19030

Copy your Month colum and Right Click 'Transform' Month - Month to get just the month.  Make this a Whole Number data type.

Now use the '1-12' numbers as your X axis and your values as the Y axis AND put value in Details.  On the Legend, you can 'Date Hierarchy' your original Date (assuming in Date format) to just the year to get your Colored cirles.

** FYI - I had to play with the X & Y Axis Start / End values to make it look better, but that's easy to do under formatting.  You can also turn on 'Fill Point' to make the bubbles solid in color!  (Looks much better!)

Thank You,

FOrrest