Heatmap

[rob_curry]

Hi there,

I am looking to build a heatmap in Power BI that will fulfill the following:

• quality rating of business process plotted on x axis (product of process quality and documentation quality from 1-5 scales, rendering a 0-25 range)
• impact rating of business process plotted on y axis (high/medium/low).

As this will cover a breadth of organisation processes, there will a number of processes that are plotted at the same coordinates. 

Having used the scatter chart tool, these overlay on top of each other and each individual plot can not be distinguished.  How do I get round this?

What is the best way to achieve this in Power BI?

Thanks,

Rob.

[Tejaswini_Dahat]

Hi there,
pls refer to this article to create HEATMAP in PowerBI

https://addendanalytics.blogspot.com/2019/08/heat-map-matrix-with-powerbi.html

[v-chuncz-msft · Accepted solution]

@rob_curry,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Avoid-overlap-in-scatter-chart/m-p/416727