Forum Discussion

abhishekpati86's avatar
abhishekpati86
Helper III
10 years ago
Solved

pch and col function not working in R using Power BI

Hi All,

 

Below is the plot function I am using to plot 2 columns where one is date range and other one is Numeric. 

 

 

I am getting the plot as desired but now I want to know 2 more things : -

 

1) Can anyone help me with why pch and col functions are not working in this plot. (highlighted below in red)

 

2) Can I get rid of the hh:mm:ss from the date range on my plot in X axis.

 

Thanks,

Abhishek 

Need Help
Show and Tell
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    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