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

a76e49c3 5c22-45d4-8c5d-2bb3e716418b on 05 Jul 2020 22:05:26

RE: Heat maps in Power View

Heat map from Tags would be great.

Tien Dung Thoi's profile image Profile Picture

cd593434 303c-4f5a-b6e3-5fb50dc81b90 on 05 Jul 2020 22:03:21

RE: Heat maps in Power View

Sorry for the excessive comments. I just thought of one more way to implement this. You can expose a stock SQL server db that comes with the PowerBI desktop install where we can insert our own map data. We did this "hack" in Tableau to use WKT instead of thousands of individual rows (1 for each vertice). I really want this program to be successful. We have had a TON of success in our organization by revealing information via maps, but there are so many ways to make it better.

Tien Dung Thoi's profile image Profile Picture

cd593434 303c-4f5a-b6e3-5fb50dc81b90 on 05 Jul 2020 22:03:20

RE: Heat maps in Power View

Honestly - just copy the way Tableau does it and that will do it. We are using Tableau for my client specifically because of the polygon maps feature. One way to do it better is to import esri shape files or to read WKT stored as either varchar(max) or spatial data types.

Tien Dung Thoi's profile image Profile Picture

cd593434 303c-4f5a-b6e3-5fb50dc81b90 on 05 Jul 2020 22:03:20

RE: Heat maps in Power View

The other use case for this is to plot custom x,y coordinates to define a retail store layout as well as "sections" of that store.

Tien Dung Thoi's profile image Profile Picture

0827ca13 01b5-4518-9c04-f43d480dcbc4 on 05 Jul 2020 22:03:16

RE: Heat maps in Power View

What is the status of Heat Map introduction in Power BI? Is it coming in near future or not? Please answer!

Tien Dung Thoi's profile image Profile Picture

747014fb ab0c-476e-943e-1634e40c5ddf on 05 Jul 2020 22:02:46

RE: Heat maps in Power View

Heat Map in PowerBI

Tien Dung Thoi's profile image Profile Picture

9401a748 d0b7-e711-8113-fc15b428ab70 on 05 Jul 2020 22:02:42

RE: Heat maps in Power View

Hi, is there an update on this feature?

Tien Dung Thoi's profile image Profile Picture

cd593434 303c-4f5a-b6e3-5fb50dc81b90 on 05 Jul 2020 22:02:27

RE: Heat maps in Power View

Please add heatmaps!! I want something like what is in Tableau where you can define your own polygons. It would be nice if we could use WKT for our own polygons. I know that SQL server supports this - I just want to be able to do it in PowerBI. Another option is to let us use an ESRI shapefile as a data source - SSRS has that feature.

Tien Dung Thoi's profile image Profile Picture

5d23b73a 0480-47da-94df-8c729a13eddf on 05 Jul 2020 22:01:04

RE: Heat maps in Power View

I'd love to have heat maps, did some in Excel Maps and the users love them

Tien Dung Thoi's profile image Profile Picture

b1c8d7db 64b1-4f35-99ae-c9dbb0832589 on 05 Jul 2020 22:00:55

RE: Heat maps in Power View

Absolutely! It would be great to drag in a measure % and have the area of the country be green to red scale based on the value. This would be huge for compliance and exception reporting.