Power BI Heat Map with Custom Visual Background

[Jarrod]

Hi All,

Currently using a scatter plot with a custom visual to display the number of incidents that have occured in a grid (eg 1000x1000). The scatter plot is hard to identify parts of the grid with high occuring events. Was hoping to use a heatmap which should allow us to better identify where higher frequency incidents are occuring.

I have tried the Heat Map in the App Source however it only seems to take lattitude and longitude values. Business Apps – Microsoft AppSource

Is anyone aware of a heat map that takes x and y values that are not GPS coordinates and also allows a custom visual background?

[Jarrod]

Hi All,

I have found that a scatter plot can display colours based on a sliding scale under data colours -> fx. This will act as a heat map.

[v-kkf-msft]

Hi @Jarrod ,

Is  the Heat Streams visual what you expect? Data is categorized and ordered along x and y axes to create a heatmap-style table of color. You can use several different color schemes such as diverging, sequential, or categorical as fits the data type. The x-axis can be any ordered bucket of your data, such as time or sequence.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@Jarrod  Deneb custom visual might work if you have time to learn Vega? Or even Charticulator may be able to do this easily enough? Not sure what you mean by custom visual background - are you wanting to superimpose your own factory or something? 

The synoptic panel visual is a really neat one too.

[Jarrod]

@AllisonKennedy Thanks for your response. I'll look into some of the options you've mentioned. 

In regards to the custom background, you are correct. While not a factory, we utilise a local grid system rather than lattitude and logitude. For example, a local grid has x values of 0 to 1000 and y values of 0 to 500. With a scatter plot, I have uploaded an image where the bottom right corner of image is (0,0) and top left corner is (1000, 500). The scatter plot is then able to plot grid coordinates across my image. Unfortunately, the scatter does not give us enough clarity and a heat map would be a better solution.

I have attached the scatter plot we are currently using, with a random background picture for anonymity purposes. Ideally there is something available that replicates this but rather than a scatter chart, we have better representation on frequency of events via a heat map.

[AllisonKennedy · Accepted solution]

@Jarrod  that makes sense. Let us know how you get on with the options. Synoptic Panel might be where I'd start, but wondering if even the scatter could still work for you if you just add conditional formatting to it?

[Jarrod]

Hi @AllisonKennedy,

I have found that a scatter plot can display colours based on a sliding scale, similar to a heat map. Thanks for your advice of continuing on with the scatter plot and conditional formatting.

[arielgonzalez]

Hi, i have the same problem, could you tell me how solved it? Thanks