Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!