Power BI - How to create a Line Chart using R script visual

To create a sample line chart using an R script in Power BI, you'll first need to have the R Integration feature enabled in Power BI Desktop. Once enabled, you can use R scripts to generate visualizations directly within Power BI. Here's a step-by-step guide to creating a sample line chart using R script:

1. Enable R Scripting:

   • Open Power BI Desktop.
   • Go to "File" > "Options and settings" > "Options."
   • Under "Global," select "R Scripting."
   • Check the box next to "Enable R scripting."
   • Click "OK" to save the changes and restart Power BI Desktop if prompted.

2. Import Data:

   • Import the data you want to visualize into Power BI. You can connect to various data sources such as Excel files, databases, or online services.

3. Create a New Report Page:

   • Click on "Report" in the left navigation pane to create a new report page.

4. Add R Visual:

   • Click on the "R Script Visual" icon in the Visualizations pane to add a new R visual to the report canvas.

5. Write R Script:

   • Drag the fields you want to use in the line chart into the "Values" section of the "Fields" pane.
   • Click on the R visual on the report canvas to select it.
   • In the "R Script Editor" pane, write the R script to generate the line chart. Here's an example script:

R
# Read data from Power BI dataset
data <- dataset

# Convert date column to Date format if needed
data$Date <- as.Date(data$Date)

# Plot line chart
plot(data$Date, data$Value, type = "l", xlab = "Date", ylab = "Value", main = "Sample Line Chart")

Replace "dataset" with the name of your dataset, "Date" and "Value" with the names of your date and value columns, respectively.

6. Run R Script:

   • Click on the "Run Script" button in the "R Script Editor" pane to execute the R script.

7. View Line Chart:

   • Power BI will render the line chart based on the output of the R script.

8. Format and Customize:

   • You can format and customize the line chart further using the formatting options available in Power BI, such as changing colors, adding titles, adjusting axes, etc.

9. Save and Publish:

   • Once you're satisfied with the line chart, save your Power BI report and publish it to Power BI Service for sharing and collaboration.

That's it! You've created a sample line chart using an R script in Power BI. You can now use R scripts to create more complex visualizations or perform advanced data analysis within Power BI.