cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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. 

 

Capture.JPG

 

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 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft New Contributor
New Contributor

Re: 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:

 

4.PNG

 

 

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

 

 

10 REPLIES 10

Re: pch and col function not working in R using Power BI

Tagging @MattAllington

Super User
Super User

Re: pch and col function not working in R using Power BI

The list below covers what I know about R in Power BI

 

 

 

 

 

That concludes the list :-)



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Re: pch and col function not working in R using Power BI

That was a cheeky response. I would appreciate if you can point out anyone who can help Smiley Happy

Super User
Super User

Re: pch and col function not working in R using Power BI

Can you post your full R script so I can see what modules you are using and any chance you can post some sample data? Also, what R runtime are you using?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Re: pch and col function not working in R using Power BI

Hey,

 

Below is the rcode I am using.

 

d1 <- aggregate(dataset$Count ~ dataset$Completed_Date,data = dataset,FUN=sum)
plot(d1,main="Completed Date Vs Count of Course Test Takers",pch=22,col="blue",xlab="Completed Date",ylab="Count of Course Test Takers",ylim=c(0,1000))

 

I have loaded a bunch of packages on R (version 3.3.1) and here goes the sample data.

 

Capture.JPG

Super User
Super User

Re: pch and col function not working in R using Power BI

OK, just as another quick question, in your R IDE outside of Power BI Desktop does it work correctly?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Re: pch and col function not working in R using Power BI

Hi,

 

I haven't uploaded this particular dataset but normal pch and col commands works fine on other dataset in my R Desktop.

 

Thanks,

Abhishek 

Re: pch and col function not working in R using Power BI

@Greg_Deckler

 

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.

 

Capture.JPG

 

Thanks,

Abhishek 

v-micsh-msft New Contributor
New Contributor

Re: 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:

 

4.PNG

 

 

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