Forum Discussion

FlowViz's avatar
FlowViz
Icon for Helper III rankHelper III
5 years ago
Solved

Scatter Chart Bubble Size

Hi Guys,   I have a table like so:   WorkItemID   CycleTimeDays  DaysSinceCompleted 34 2 -1 35 2 -1 36 6 -1.25 37 7 -2   Which is visualised in a scatter chart (Cycl...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi FlowViz 

Yes, using jitter for overlapping ponts will avoid the need for larger bubbles.

I'm not sure what your subsequent comment means : over time (as DaysSinceCompleted increases) the jitter won't work as the new measure will give a range of results since it was completed ?

If you aren't going to or can't use jitter, will you just use the larger bubble solution?

Regards

Phil