Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scatter Chart Jitter

Hi,

 

I was wondering if there was a way to create a scatter chart where the plots are "jittered", or not stacked on top of each other like the screenshot below... I saw some people using R but I am not able to follow what they are doing as i am not as familiar with R

 

Please let me know if my question does not make sense

 

Thank you!
Sarah

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • jhaines's avatar
    jhaines
    Frequent Visitor
    5 years ago

    I came across the same need as you. I added a calculated column using the RAND DAX function:

     

    Jitter = RAND()

     

    I then added that column as my y-axis (in your case you can add it to the x-axis) and got the jitter I was looking for.

     

     

  • TomMartens's avatar
    TomMartens
    Super User
    6 years ago

    Hey Anonymous ,

     

    jitter is not supported by the default Power BI visuals.

    Maybe a custom visual supports this feature.

     

    You can also try to use a custom column with a hexcode like so #32a85260 as the first 6 characters represent the color (some kind of green) the last 2 digits represent opacity. This might help to reduce the overplotting effect using default visuals.

     

    Regards,

    Tom