Forum Discussion

carlossantiago's avatar
carlossantiago
Frequent Visitor
8 years ago
Solved

Plotting R charts in Power BI

Hi guys,

 

My scripts just don`t work. I've tryed a very simple example in RStudio and Power BI R Script Editor.

 

The script is:

a<- c(1:10)
b<- c(20:29)
c[1]<-sum(a)
c[2]<-sum(b)
barplot(c)
title("my bar")

 

See below the outputs I have:

 

In R Studio:

R Script Editor:

 

 

Does anyone can help me to make it work?

 

 

Thanks,

 

 

Carlos Santiago

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi carlossantiago,

    I try to reproduce your scenario and get expected result, please review the steps below.

    1. I create the bar chart in R as follows. Please add the command: c<-c(0,0), otherwise, it will returns the error message like yours.

    a<- c(1:10)
b<- c(20:29)
c<-c(0,0)
c[1]<-sum(a)
c[2]<-sum(b)
barplot(c)
title("my bar")





    2. Then I will get the same result in Power BI desktop. 

    2.1 You must import the data before you create visual. So I click "Enter Data", type the following data.



    2.2 Click R visual->select the a,b as value field, it will create the dataset automatically(please see the part highlighted in black box), which is a Power BI by design behavior. Then type T script(highlighted in yellow box), you will get expected result.

          

    c<-c(0,0)
c[1]<-sum(dataset[,1])
c[2]<-sum(dataset[,2])
barplot(c)
title("my bar")


    From your screenshot, what are c3 and c2?

    Best Regards,
    Angelia

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi carlossantiago,

    I try to reproduce your scenario and get expected result, please review the steps below.

    1. I create the bar chart in R as follows. Please add the command: c<-c(0,0), otherwise, it will returns the error message like yours.

    a<- c(1:10)
b<- c(20:29)
c<-c(0,0)
c[1]<-sum(a)
c[2]<-sum(b)
barplot(c)
title("my bar")





    2. Then I will get the same result in Power BI desktop. 

    2.1 You must import the data before you create visual. So I click "Enter Data", type the following data.



    2.2 Click R visual->select the a,b as value field, it will create the dataset automatically(please see the part highlighted in black box), which is a Power BI by design behavior. Then type T script(highlighted in yellow box), you will get expected result.

          

    c<-c(0,0)
c[1]<-sum(dataset[,1])
c[2]<-sum(dataset[,2])
barplot(c)
title("my bar")


    From your screenshot, what are c3 and c2?

    Best Regards,
    Angelia