Forum Discussion
Helper IIIScatter Chart Bubble Size
Hi FlowViz
Download PBIX with these examples
Yes you can use this measure for bubble size
Bubble Size = CALCULATE(COUNTROWS('Table'), FILTER(ALL('Table'), 'Table'[CycleTimedays] = SELECTEDVALUE('Table'[CycleTimedays]) && 'Table'[DaysSinceCompleted] = SELECTEDVALUE('Table'[DaysSinceCompleted])))To give this
You might also consider introducing jitter to one of the axes to shift overlapping points slightly.
This measure shifts the x value slightly for points that overlap. It uses the [Bubble Size] measure from above.
Jittered X = IF([Bubble Size] > 1, SELECTEDVALUE('Table'[DaysSinceCompleted])*(RAND()), SELECTEDVALUE('Table'[DaysSinceCompleted]))Giving this visual. The amount of jitter/shift for each point can be tweaked so it's not shifted too much.
Further info on jitter Jitter in Excel Scatter Charts • My Online Training Hub
Regards
Phil
Helper IIII think the larger bubble solution works better. DaysSinceCompleted is calculated using NOW()-Closed Date. So over time this will increase and using jitter could skew how many days since it was actually completed.
With the larger bubble, is it possible to do a custom tooltip that would show the data for each item on hover?
HI FlowViz,
Perhaps you can take a look at the following link to know more about creating a custom report tooltip page if it is suitable for your requirement.
Create tooltips based on report pages in Power BI Desktop
Regards,
Xiaoxin Sheng