Forum Discussion
Plotting R charts in Power BI
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
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