Forum Discussion

abhishekpati86's avatar
abhishekpati86
Helper III
9 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 thin...
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

     

     

abhishekpati86's avatar
abhishekpati86
Helper III
9 years ago

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's avatar
Greg_Deckler
Community Champion
9 years ago

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

  • abhishekpati86's avatar
    abhishekpati86
    Helper III
    9 years ago

    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's avatar
      abhishekpati86
      Helper III
      9 years ago

      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's avatar
        v-micsh-msft
        Microsoft Employee
        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