How to separate preview data when hovering over items on heatmap

[tcouey]

Hi, and thank you all for any help.

I have risks that display scores on a heatmap. Sometimes, these risks have the same scores, which gives them the same dot on a heatmap. 

However, when you hover over one of the items on the heatmap, you only see one risk associated to that value. If you click on dot on the heat map, it filters on one of the risks, and not both. (there are other tables on this dashboard with other data points related to the risks in the heatmap)

Any ideas to separate these items on the heatmap? 

[PhilipTreacy · Accepted solution]

Hi @tcouey 

You can add jitter to the points so they don't 100% overlap

Have a read of these posts which explain the idea with examples

Jitter in Excel Scatter Charts • My Online Training Hub

Using Jitter to Avoid Over Plotting in Power BI • My Online Training Hub

regards

Phil