Bubble size on scatter w/ custom tooltip

[FlowViz]

Hi guys,

I have a scatter chart as follows, with a custom tooltip which when you hover on it gives the details on a point:

Unfortunately, there are instances where some items have the same Cycle Time Days and DaysSinceCompleted, see PBI 34 & 35 when viewing the visual as a table:

So these two bubbles overlap 😞

What I'd like to get to, is to have a solution when where there are overlapping bubbles (same Cycle Time and Days Since Completed), there is a bigger bubble viewed, and when hovering on the bigger bubble you see the details for both items (i.e. not just one).

Is this possible? I have attached the pbix file here

[MFelix · Accepted solution]

Hi @FlowViz ,

The question about your data is that the information is not exactly the same, if you take out the Title 34 and Title 35 you will see that the Cycle time is different:

Altough you have set the formatting to 2 decimals this is only formatting so only for visualization in reality you values differ from each other.

What I did was to create a new column:

Cycle round = ROUND('WorkItems Completed'[CycleTimeDays],2)

Now I use this has my Y-axis and place the count of the title on the size of the bubbles

Result below and in attach PBIX file. Sorry the constant line are not the same has yours but with the change of the axys they need to be redone.

[FlowViz]

Amazing thank you 🙂