Skip to main content

Power BI

Needs Votes

Error bars

Vote (211) 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 (22)
Viktor Ferenczi's profile image Profile Picture

3149272f 02ca-4362-99f6-fe9adfd9ef27 on 05 Jul 2020 23:47:56

RE: Error bars

Error bars would dramatically increase the usability of PowerBI at our institution.

Viktor Ferenczi's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:47:20

RE: Error bars

An idea for integration would be to use the conditonal formatting pop-up that already exists within tables as a template for error bars as well.

The inability to show uncertainty within the standard visuals is very limiting, but I can see how it would alienate others as well. Hiding them in its own menu would be a good compromise.

Viktor Ferenczi's profile image Profile Picture

90c75bfb 7207-4803-8fd7-c2d8209cf6d8 on 05 Jul 2020 23:45:43

RE: Error bars

Very surprising to me that this feature isn't already included! PowerBI already has the data - users should be able to set their confidence interval and have error bars appear on charts.

Viktor Ferenczi's profile image Profile Picture

fd5cad4e 3f81-4992-b20a-9453846c8176 on 05 Jul 2020 23:36:10

RE: Error bars

Desperately need this feature!

Viktor Ferenczi's profile image Profile Picture

791cc56d a1d2-44dc-84cc-5ed18ea8ee69 on 05 Jul 2020 23:35:57

RE: Error bars

Still waiting, would greatly appreciate if you could add this option to basic charts

Viktor Ferenczi's profile image Profile Picture

3aecf7ce 76f6-4c67-b022-a511f51136cd on 05 Jul 2020 23:34:36

RE: Error bars

Need this.

Viktor Ferenczi's profile image Profile Picture

4ef46501 5fab-4ded-839a-272ab339f093 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

4ef46501 5fab-4ded-839a-272ab339f093 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

8c62d64e 30a1-49c3-a4d7-e9b8dee33a1e 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

78990693 cead-4fb3-98d6-841193024a71 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.