Plotting R charts in Power BI

[carlossantiago]

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

[v-huizhn-msft · Accepted solution]

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