Create a Custom Chart in R without Data Input

Anonymous · ‎11-04-2020

Hi guys,

I have successfully created a chart in R and would like to distribute it to other people in my team as a custom chart pbiviz. After following Datacad tutorial here, I have managed to create a custom visual pbiviz file. However, it would require data for the visualisation to run and if you change to other dataset by ticking in fields in PowerBI, the chart will remain the same. I have tried to add this code at the beginning of my script.r file in after using " pbiviz new chart -t rhtml" command and hope it will only be active if there is no dataset.

"""

if(!exists( "dataset" ))
{
second = c(120, 60, 30, 20)
first = c(100, 60, 40, 30)
stage = c("Started", "Thinking", "Trial", "Final")
dataset <- data.frame(stage,first,second)
}

"""

However, after importing the chart into PowerBI and clicking on new dataset on fields, the new data is still not imported into the chart but the chart only use the default dataset mentioned above.

Is there anyway I can create a custom chart in R without specifying the data and then the data can be choose later by ticking in Fields?

Thank you,

@R @CustomChart @pbiviz

Anonymous · ‎11-16-2020

Hi @Anonymous

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

Anonymous · ‎11-16-2020

Hi RicoZhou,

I have tried Charticulator but it didn't provide the same functionalities like R plotly package. I would like to input the data in a R-custom chart (or python custom chart).

So sorry, it didn't answer my question.

Thanks