Forum Discussion

Erin's avatar
Erin
Helper I
10 years ago

scatter chart, point size

Hi,   I have a scatter chart on my dashboard, and I am looking for a way to shrink the size of the pints on the chart. Since I have large amount of data on the chart, I would like to see just a sma...
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Erin,

 

In a scatter chart, if we do not add value to size, then each bubble has the same size.

If we add value to szie, then the bubble size is chanaged based on the values on size automically.

Reference
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-scatter/

 

If this is not what you want, please elaborate your issue, if possible provide us some screenshots, so that we can make further analysis.

 

Regards,

Charlie Liao

willsmithorg's avatar
willsmithorg
Advocate I
10 years ago

I have the same problem.  I suspect it can't be done with current functionality.  Even if I create a column like

 

PointSize = 0.2

 

Then set 'Size' to 'Average of PointSize' 

 

I then get huge circles.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Though it has known limitations (see https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-visuals/), an R visual lets you control more features, but can be fiddly to format just right I suspect - e.g. simple scatter plot:

     

    library(ggplot2) # Needed for ggplot

    # Avoid having to reference dataset$ each time in function calls
    attach(dataset)

    #Plot the dataset by XAxis and YAxis, with Value to set the fill colour
    ggplot(dataset,aes(x=`XAxis`, y=`YAxis`, colour=`Value`)) +

    #Plot as (filled) points with a dot of size 2.8mm (2.8mm =~8 pt)
geom_point(size=2.8)