Get map to present exact value instead of sum

[Sherly_m]

Hi all, 

I am very new with Power Bi and I am building a visualisation using map bubbles.

I would like to show "number of cars" across countries and years for 4 years (2006,2007,2008,2009). 

When I put my variable on the map, the bubble size show count of "number of cars" instead of the exact value. For example, it shows "3" if I have data for 3 years or "4" if I have the data for 4 years.. 

What I did so far was to:

1. Change the value as "sum"

2. Add "year" as a filter, so if my audience chooses 2006, the number of cars in 2006 will show.

Is there a way for me to set this without setting a filter for a specific year? For example, if they did not filter any date, it will show the lastest year, i.e. 2009.

Thank you. 

[vanessafvg · Accepted solution]

depending on how your data looks, which is very difficult to say because you haven't provided sample data

but you could do something like this

number of cars - this year
Was current year
Year ( Maximum ( [date] ) )
Return
Calculate ( Sum ( table[number of cars] ), currentyear = Year ( [date] ) )

[Sherly_m]

Dear Vanessa, 

Thank you for the code. Does it mean I should create a new measure and then put the new measure in the "values" field? 

I use a free version so I can't share my file.... Here is the screenshot. 

Thank you. 

[vanessafvg]

correct you would create a new measure and then put it in the size  area

you can still share with the free version however you have to do it with the pbix file by uploading to dropbox and sharing it.