The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Experts
I am trying to plot the following in R.....but not sure where i am going wrong, I have check that the R libraries are availble on the Microsoft Cloud...This plots fine in R Studio.
my data points are 33,35,34,35,22,24,26,30,20,26,33,18...
#Begin first set of commands library(ggplot2) library(trend) library(zoo) library(dplyr) library(Kendall) #End of first set of commands #Begin second set of commands data1 <- ts(c(33,35,34,35,22,24,26,30,20,26,33,18), start=c(2018, 1), end=c(2018, 12), frequency=12) mk.test(data1) data1X <- c(1:length(data1)) data1Fit <- lm(data1~data1X) data1df <- data.frame(date=as.Date(time(data1)), Y=as.matrix(data1)) ggplot(data=data1df, mapping=aes(x=date, y=Y, ymin = 0))+geom_point() + geom_line(color='blue') + stat_smooth(method = "lm", col = "red") + xlab("Months") + ylab("Complaints") + scale_x_date(date_breaks = "1 month", date_labels = '%b %y') + labs(title = paste("Adj R2 = ",signif(summary(data1Fit)$adj.r.squared, 5), " Slope =",signif(data1Fit$coef[[2]], 5))) #End of second set of commands
Solved! Go to Solution.
hi, @Anonymous
It should be that "trend" package is not supported in Power bi but it is supported in R Studio.
here is the document for you refer to:
https://docs.microsoft.com/en-us/power-bi/service-r-packages-support
Best Regards,
Lin
hi, @Anonymous
It should be that "trend" package is not supported in Power bi but it is supported in R Studio.
here is the document for you refer to:
https://docs.microsoft.com/en-us/power-bi/service-r-packages-support
Best Regards,
Lin
HI Lin
I have removed the Trend Package - and agree. So are you saying now that the code should work just fine,
User | Count |
---|---|
79 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
108 | |
99 | |
55 | |
49 | |
46 |