Skip to main content

Power BI

Completed

Heat maps in Power View

Vote (1428) Share
Tien Dung Thoi's profile image

Tien Dung Thoi on 23 Jan 2015 18:43:36

It'd be REALLY nice to have heat maps capabilities in the map visualization of Power View, like those in Power Maps.

This is an OFTEN requested feature from our large enterprise customers

Administrator on 30 Mar 2019 09:02:23

We are very excited to announce that we have shipped a heatmap layer as part of our built-in Bing map visual. You can read the details on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2019-feature-summary/#heatMap

Comments (65)
Tien Dung Thoi's profile image Profile Picture

01671dee 56cf-4ea2-84b2-1d5cb51767a9 on 05 Jul 2020 23:59:29

RE: Heat maps in Power View

Heatmap on custom map (like flor plan) is still not available. Could you please look into thsi as well?

Tien Dung Thoi's profile image Profile Picture

6b9d867d 51a8-4ffc-8a98-f7325ec78dce on 05 Jul 2020 23:42:28

RE: Heat maps in Power View

Heat maps would be very ideal for me especially when I do my analysis to understand where our clients are spending more time on the Power BI dashboard and what they are clicking most.

Tien Dung Thoi's profile image Profile Picture

df852711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 23:41:59

RE: Heat maps in Power View

ESRI is a nice option but a big gap are those heat maps are not allowed to be Published to Web. T

In addition, the visual is pretty slow to load.

And, ESRI heat map does not work on aggregations....e.g. Sum(Revenue).

Tien Dung Thoi's profile image Profile Picture

813f701c bf39-43df-8caf-7209182403b1 on 05 Jul 2020 23:36:41

RE: Heat maps in Power View

ESRI "Heat Maps" are misleading because they only plot the heat signature based on the NUMBER OF POINTS in a given area, NOT an AGGREGATE of any field! In fact, I found one other major vendor of custom visuals claiming to have 'heat map' capability but in fact also only plotted the COUNT of points.

For it to be a TRUE heat map, you need a way to AGGRAGATE a value.

For example, if I have 300 people in near location A and each bought 1 widget, and I had 100 people in location B that bought 10 widgets each, an ESRI Heat Map would show that there was higher activity around location A.

Tien Dung Thoi's profile image Profile Picture

f020ab10 9c8f-44e6-ad84-f24a2ea17ea0 on 05 Jul 2020 23:24:04

RE: Heat maps in Power View

Not sure what this is. Heatmaps is just conditional formatting of a table. We can do this already in PBI.

Tien Dung Thoi's profile image Profile Picture

40502e40 76ce-4f42-b63d-31ddf675aac9 on 05 Jul 2020 23:12:54

RE: Heat maps in Power View

Shouldn't this be marked as completed? ARCGIS is one option, and Mapbox is about to provide an alternative in the store (it's already on Github).

Tien Dung Thoi's profile image Profile Picture

775d11f4 b25a-4032-9708-06ff41beded6 on 05 Jul 2020 22:52:19

RE: Heat maps in Power View

We definitely need more clarification onexactly what data ESRI collect. From a UK perspective, using the ArcGIS maps add-on to process any personal data would appear to be in breach of the Data Protection Act.

Tien Dung Thoi's profile image Profile Picture

e646e296 95dc-408f-89a5-05be85559384 on 05 Jul 2020 22:44:13

RE: Heat maps in Power View

I am currently integrating this functionality to a Google Maps Visual.

Tien Dung Thoi's profile image Profile Picture

a63c1566 133c-42e8-9122-8689baf18dcd on 05 Jul 2020 22:43:49

RE: Heat maps in Power View

Have anyone's concerns been address about data security for this item? The concerns below seem valid and prohibit me from using some feature or the tools at all as well.

Tien Dung Thoi's profile image Profile Picture

e92f5a25 c6ed-4a92-8578-caa26b85c323 on 05 Jul 2020 22:32:17

RE: Heat maps in Power View

I am also very concerned about data security. My implementation cannot have data the data touching a third party (beyond Microsoft). It's not clear in ESRI privicy policy if they are collecting "personal" information (name/contact info) which is fine, or actually collecting data being used for visualizations.