Skip to main content

Power BI

Needs Votes

Error bars

Vote (298) Share
Viktor Ferenczi's profile image

Viktor Ferenczi on 06 Apr 2016 19:30:10

We often have additional statistical information on our data points, like min/max, standard deviation (error), percentiles, etc.

It would be nice to be able to render at least error bars showing the confidence interval for our data points.

Standard deviation could be provided on a separate column which we could drag into the visual.

It would be nice to have this basic feature in the base product without having to install custom visuals. (I could not find a custom visual for this either.)

Comments (27)
Viktor Ferenczi's profile image Profile Picture

Power BI User on 05 Jul 2020 23:34:36

RE: Error bars

Need this.

Viktor Ferenczi's profile image Profile Picture

James JamesPerry on 05 Jul 2020 23:19:08

RE: Error bars

Has anyone produced a custom visual that does this yet? This function is really needed when displaying statistical data. It needs to have the ability of entering your own value rather than just calculating SD.

Viktor Ferenczi's profile image Profile Picture

James JamesPerry on 05 Jul 2020 23:07:07

RE: Error bars

Agree this would be good - and something along the lines of how you add them in Excel would work. Someone could create an r visual to do this, but it could be added to the existing bar and line graph visuals.

One approach is already available but it calculates SD rather than allowing you to enter error bar values http://community.powerbi.com/t5/R-Script-Showcase/Bar-Chart-with-Error-Bars/m-p/71763/highlight/true#M55

Viktor Ferenczi's profile image Profile Picture

Stephen Paul Wright on 05 Jul 2020 23:03:43

RE: Error bars

The Excel way would be OK, but we also need to be able to plot a line with a confidence band around it - like the projection feature

Viktor Ferenczi's profile image Profile Picture

Mike on 05 Jul 2020 22:37:19

RE: Error bars

This would be tremendous. I am constantly working around the absence of confidence bands in other tools. Ideally, I'd like to show a time series with an area (for confidence) and line for predicted/observed as well as a slider/slicer to filter.

Viktor Ferenczi's profile image Profile Picture

Adam on 05 Jul 2020 22:32:51

RE: Error bars

Yes, this is essential, we need people to understand the intelligence not just the data and without this people fixate on hard values. Really need to be able to integrate CIs / error bars into as much of this as possible please.

Viktor Ferenczi's profile image Profile Picture

Ken Jones on 05 Jul 2020 22:23:17

RE: Error bars

Standard deviations is a critical visualization for all our work. I'd really love this feature because we do them in other tools today.