Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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
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.
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.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |