Forum Discussion
wes-shen-poal
9 years agoHelper III
Make blank cells as NAs in R script visual
HI there, Can someone kindly advise me on how I can make the blank cells in my dataset (i.e. the columns I have chosen) for a R Script Visual to be NAs within the R Script Editor? The way I o...
dkay84_PowerBI
9 years agoMicrosoft Employee
Try adding a calc column within PBI that checks for blank and returns "NA" otherwise returns the value, then use this new column in your visual
- wes-shen-poal9 years agoHelper III
thanks dkay84_PowerBI
Do you know if there's a way I can do this within the R Script Editor (without having to create a new calc column)?