Time Series Heat Map

[Anonymous]

Hello Experts, Need your help.

I have huge data of crime occured at particular location. Here is the snippet of sample data.

Based on this I need to create a heat map which shows the location and crime at particular processed time. As of now this would be static data representation and later on I may need to create a streaming data set with power bi API so the data would flow according to processed time. I am not sure how should I proceed with this.

I have tried with ArcGCIS, Globe maps but its not working for me. I have even downloaded the HeatMap visual from the below link but not sure how to use this.  There is a link provided on how to use this but the link appears broken.

https://community.powerbi.com/t5/Best-Visual-Contest/Heatmap/cns-p/7551

Could anyone have any idea or any other visual which will help me in this? Please advise.

Thanks!

[rohitnadgiri]

Hi,

I have a very similar probelm. I want to represent an ordinal variable (i.e. an index) changing over time (animated) for several locations on a heat map. I have used the heatmap visual suggested by @Eric_Zhang. However, the map is designed for categorical variables and not ordinal. Can anybody help me out here?

PS - I am sharing this post after several disucssions with Microsoft developers.

[Eric_Zhang]

---

@Anonymous wrote:

Hello Experts, Need your help.

I have huge data of crime occured at particular location. Here is the snippet of sample data.

Based on this I need to create a heat map which shows the location and crime at particular processed time. As of now this would be static data representation and later on I may need to create a streaming data set with power bi API so the data would flow according to processed time. I am not sure how should I proceed with this.

I have tried with ArcGCIS, Globe maps but its not working for me. I have even downloaded the HeatMap visual from the below link but not sure how to use this.  There is a link provided on how to use this but the link appears broken.

https://community.powerbi.com/t5/Best-Visual-Contest/Heatmap/cns-p/7551

Could anyone have any idea or any other visual which will help me in this? Please advise.

Thanks!

---

@Anonymous

There's a heatmap in the custom visual store, see Heatmap. You could follow the steps.

As to how to push data via REST API, you could reference Push data into a Power BI dataset. Do note that you can only push data to the datasets which are created via REST API.

[Anonymous]

Hi @Eric_Zhang, thanks for your inputs. I have used the visual as mentioned but there is no option to have heat data e.g. I need to show where crime has occured more in some top layer. Are you aware of any other map visual for this?

Please advise, thanks!

[Anonymous]

Hello All- Anyone has expert advise on this? Appreciate any help, please, thanks!