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

     

     

  • MattAllington's avatar
    MattAllington
    Community Champion
    10 years ago

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

     

     

     

     

     

    That concludes the list :-)

    • abhishekpati86's avatar
      abhishekpati86
      Helper III
      10 years ago

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

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        10 years ago

        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?