Mike_Carlo's avatar
Mike_Carlo
Most Valuable Professional
9 years ago
Solved

Bar Chart with Error Bars

 

 

 

 

 

 

 

 

 

 

 

 

 

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

4 Replies

  • Sharon's avatar
    Sharon
    Microsoft Employee

    this is very interesting.  LIke!

  • Anonymous's avatar
    Anonymous
    Not applicable

    The solution no longer works.

     

    Keep getting this error message:

     

     

  • boefraty's avatar
    boefraty
    Microsoft Employee

    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's avatar
      jamesperry
      Frequent Visitor

      Has anyone converted this into a custom visual yet?