Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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.
@harshadsp 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!
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.
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!
Hello All- Anyone has expert advise on this? Appreciate any help, please, thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |