Bar Chart with Error Bars 09-25-2016 19:38 PM - last edited 12-22-2016 19:52 PM

[Mike_Carlo]

Description

This is a chart that was built to show pricing of various products.  The data set contains many different prices for each product.  Therefore the bar is the average price and the error bars (whiskers) are portraying the one standard deviation away from the mean.

Learn It

The following tutorial uses the same R script shown here.  You can find more interesting power BI tutorials at www.powerbi.tips

Prerequisites (The sample .pbix files won't work without installing the following)

1. Install R Engine

Power BI does not include the R engine.  Therefore, a seperate installation is required to install R on your local computer.  You can download R from the Revolution Open download page, and through the CRAN Repository.

2. Install the R packages

Once R engine has been installed you can dowload the package from the Revolution Open Package Downloads Page. 

Required R Packages

ggplot2

Tested on

MRO 3.3.1, CRAN 3.3.1

[swragg]

The solution no longer works.

Keep getting this error message:

[boefraty]

Hi Michael,

Your inputs for "R Script Showcase" are very impressive and valuable.  If you consider to convert some of your R-visuals to R-powered-custom visuals, out team will be happy to assist you. 

The visibility of R-powered custom visuals is greater and it is not limited for R-users. 

[jamesperry]

Has anyone converted this into a custom visual yet?  

[Sharon]

this is very interesting.  LIke!