Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi!
i would like to know if we can edit dataset values by using R visual (and not R script in query)
For example : "dataset$values[i]=10" gives"unexpected input" as error
Hi @Paheli,
Based on error message, it think you inputted wrong script in r visual.
You can try to use below formula to modify specific element from data frame:
dataset[i,"values"] <- 10
Reference link:
Regards,
Xiaoxin Sheng
@Anonymous thanks for your reply but nothing happen when excute the code
here below the screenshot:
Hi @Paheli,
According to your screenshots, I found you use '=' to replace '<-', I'm not so sure if character '=' can work as '<-' in r script.
Maybe you can modify it and try again.
Regards,
Xiaoxin Sheng
Unfortunatley it doesn"t work even with <- or =
Try loading your code in R Studio and debug it there, it will be easier and that will rule out Power BI issues.
actually i us notepad to write my code and i test the code on powerbi because i try to edit a table within powerbi
@Anonymous
As a solution i plotted my tables on the R visuals it's a little bit limited because i can't select my data.
thank you for your reply
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 32 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 71 | |
| 59 | |
| 39 | |
| 22 | |
| 21 |