How to show 95% confidence interval in a histogram?

[pborah]

I have a histogram with reference lines created for Mean, Median, and St Dev. The histogram was created using bins (groups) created in PowerBI. I wish to show reference lines for 1 and 2 sigma on both sides of the mean. How can I achieve this?

[lbendlin]

You would use the same reference line approach?  Are you sourcing them from the Analysis tab, or do you create them from the data?

[pborah]

Line field calculations do not contain preset calculations for 2xStDev. Neither is there any toggle option to show area of distribution covered by +-2xStDev

As of atleast the February update for PBI, there is no separate "Analysis" tab. But to answer your question yes, I'm calculating them from what would have been the analysis tab in previous versions.

[lbendlin]

Would you mind sharing some sample data and to indicate the expected result?

[pborah]

Unfortunately I can't share sample data. You can actually create test data yourself. You literally just need one column of any random numerical values. Thereafter you can create bins for in it PowerBI and then create the histogram using a stacked column chart visual - bins on X axis and count of observations on Y. In my case the distribution is normal but yours doesn't have to be since you're just going to be testing out whether the calculation is possible.

Stats 101 says that if your data is normally distributed (skewed or not), approximately 95% of the observations should fall within two standard deviations on either side of the mean. That's what I'm trying to show in this visual.

[lbendlin]

I woudn't even know how to calculate the mean for that. Do you have to interpolate between the under/over bins on the halfway line?