PowerBI bubble map - can a bubble show the average of a column?

[tkleiber]

Hello

I would like to create a bubble map where a user can choose a time period and then sees the average temperature of this period for various places. (as it can be easily done with diagrams in PowerBI)

So far I couldn't manage it. Is there a way to do it?

My datas include the following columns: name of the station, coordinates, date, temperature of the day

Any hint or solution is appreciated

[tkleiber]

Hi @v-rzhou-msft 

Thank you very much! Your solution is very helpful! 🙂

Best Regards

Thomas Kleiber

[tkleiber]

Thank you very much @v-rzhou-msft .

But my idea was to show the average temperature with the color code of the station. (For example: all the stations with an average temnperature below 0 degrees have blue colors, all the others red colors.)

But anyway thanks for the reply 🙂

Best regards
Thomas

[v-rzhou-msft · Accepted solution]

Hi @tkleiber 

You can try conditional formatting function to custom the color. For using this function, you can't use legend in this visual.

I build a measure to caluclate the average temperature for each station and build a measure which could be added into the data color (color field).

Measure:

Average of temperature = AVERAGEX(FILTER('Table','Table'[Station Name]=MAX('Table'[Station Name])),'Table'[temperature of the day])

Color = 
IF([Average of temperature]<0,"Blue","Red")

Build a bubble map visual and add color measure into data color.

Result is as below. It will show bubbles which average >=0 in red and others in blue.

For more details for conditional formatting you may refer to this blog: Use conditional formatting in tables

You can download the pbix file from this link: File

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[v-rzhou-msft]

Hi @tkleiber 

I think you may want to show the average temperature of select period for various places.

Due to I don't know values in your data model, I build a sample table to have a test.

Sample Table:

Build a slicer by Date column and build a map visual as below.

Add temperature column in Size and use average function.

Now Avg of temperature of Wisconsin is 15+10/ 2 = 12.5

You can download the pbix file from this link: PowerBI bubble map - can a bubble show the average of a column

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.