cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

R script colouring

I'm currently trying to run the following script through my R visual in Power BI:

library(scatterplot3d)

x <-dataset$Week.Calendar
y <-dataset$ICU.Stay
z <-dataset$Age.Years

scatterplot3d(x,y,z,
colour=as.numeric(dataset$County.Event),
pch=1,
xlab="Week",
ylab="ICU Stay",
zlab="Age",
angle=dataset$Angle[1])
 
I know there's a distinction between color & colour but every time I enter color i get blank values in my image:
ICU Stay2.PNG
 
Do i have to define the RGB colours / colors in the script to get the to show?
 
Thanks in advance,
1 ACCEPTED SOLUTION
Super User IV
Super User IV

Using "color" is correct.  I'm not sure why as.numeric isn't working here, but this code seems to.

 

x <-dataset$Week.Calendar
y <-dataset$ICU.Stay
z <-dataset$Age.Years
colors <- dataset$County.Event
newcolors <- rainbow(length(unique(colors)))[as.numeric( as.factor(colors))]

scatterplot3d(x,y,z,
color= newcolors,
pch = 1,
xlab="Week",
ylab="ICU Stay",
zlab="Age",
angle=dataset$Angle[1])

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
Super User IV
Super User IV

Using "color" is correct.  I'm not sure why as.numeric isn't working here, but this code seems to.

 

x <-dataset$Week.Calendar
y <-dataset$ICU.Stay
z <-dataset$Age.Years
colors <- dataset$County.Event
newcolors <- rainbow(length(unique(colors)))[as.numeric( as.factor(colors))]

scatterplot3d(x,y,z,
color= newcolors,
pch = 1,
xlab="Week",
ylab="ICU Stay",
zlab="Age",
angle=dataset$Angle[1])

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors