Forum Discussion
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...
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.
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)