pch and col function not working in R using Power BI

[abhishekpati86]

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 

[abhishekpati86]

Tagging @MattAllington

[MattAllington]

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

That concludes the list 🙂

[abhishekpati86]

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

[Greg_Deckler]

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?

[abhishekpati86]

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.

[Greg_Deckler]

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

[abhishekpati86]

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 

[abhishekpati86]

@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.

Thanks,

Abhishek 

[v-micsh-msft · Accepted solution]

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

[abhishekpati86]

@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