Using R scripts in Power BI - Visualization
If you code in R, you have in some cases worked with applications that enable you to use R. One of those that I constantly work with is Power BI. There are many visual options available in Power BI including links to custom ones. On the visuals landing tab, you can pick R or Python Scripts as a method to create your desired visual. In this blog, I will demonstrate how to create the visual below (Some have called it a progress bar). Access you visuals page on Power BI, choose the R script, choose the table columns you need for the visual. Power BI will combine the columns into a data frame called dataset that is available for use. You can rename it data or whatever you decide. For this case, I have to create the dataset instead of using one from power BI Create the data frame and set seed to replicate results set.seed(5) data <- data.frame(Facility = c(rep("A",3), rep("B", 3), rep("C",3), rep("D", 3)), Year = r...