Skip to main content

Power BI

New

Scatterplot jittering

Vote (60) Share
Alex Dantin's profile image

Alex Dantin on 13 Oct 2015 01:09:02

Jitter is a technique for scatterplots which allow multiple datapoints which have the same value to be displayed

Comments (3)
Alex Dantin's profile image Profile Picture

f66b7e42 1c77-4dfe-bcc5-c8ff88306631 on 06 Jul 2020 00:12:21

RE: Scatterplot jittering

Yes, badly needed! Otherwise any discrete but particularly weekly, monthly etc scatterplots look pathetic and hide values (even with transparency).

Rob Collie's solution is excellent, but we can't fiddle applying DAX custom clustering each time, when it could be easily built into the scatterplot itself for the very EDA it was built for (like R, Python etc - and we don't want to resort to those either, as we lose all the interactivity!).

Half a decade later and no update - please sort it out!

Alex Dantin's profile image Profile Picture

1d42712a 2491-444b-81ca-0ff4bbfda4ed on 05 Jul 2020 23:04:47

RE: Scatterplot jittering

Though it should be an option for the standard scatterplot visual, see Rob Collie's solution for how to achieve this here - https://powerpivotpro.com/2017/11/jittered-scatter-charts-power-bi-via-dax-power-query/

Alex Dantin's profile image Profile Picture

f66b7e42 1c77-4dfe-bcc5-c8ff88306631 on 05 Jul 2020 22:55:44

RE: Scatterplot jittering

Agreed. PowerBi Scatter Chart is excellent, but without jitter (like R ggplot), it can become useless when you can't see multiple datapoints with same values.