Forum Discussion
pch and col function not working in R using Power BI
Hi abhishekpati86,
The chart is only able to show the year range under R when using the as.date (date format) function in R.
d1 <- aggregate(dataset$sales ~as.Date(dataset$date, orgin="%m/%d/%Y"), data=dataset,FUN=sum)
plot(d1,main="date Vs sales",pch=22,col="blue",xlab="date", ylab="sales",ylim=c(500,800))
The below is the as.date function reference:
https://stat.ethz.ch/R-manual/R-devel/library/base/html/as.Date.html
See the result:
Check and see if this would be helpful. I will also take a further look into the X range part, and if any helpful things, I will post back.
Regards
Hi All,
I was able to solve the last issue but now I am not able to format the X axis dates to mm-dd-yyyy format.
Currently my date field in x axis is showing in yyyy-mm-dd hh:mm:ssss.
Thanks,
Abhishek
Hi abhishekpati86,
The chart is only able to show the year range under R when using the as.date (date format) function in R.
d1 <- aggregate(dataset$sales ~as.Date(dataset$date, orgin="%m/%d/%Y"), data=dataset,FUN=sum)
plot(d1,main="date Vs sales",pch=22,col="blue",xlab="date", ylab="sales",ylim=c(500,800))
The below is the as.date function reference:
https://stat.ethz.ch/R-manual/R-devel/library/base/html/as.Date.html
See the result:
Check and see if this would be helpful. I will also take a further look into the X range part, and if any helpful things, I will post back.
Regards
v-micsh-msft -- Thanks Michael, it did solve the issue. My pch and col functions that didn't work earlier have also started responding.
Cheers,
Abhi