Levey Jenning Standard Deviation

[all4ephraim]

Hi,

i need your assistance with plotting a Levey Jennings standard deviation chart that has a constant line which would be the mean of (calculatedConcentration column) and shows +1,+2,+3 Standard deviation from the MEAN(calculatedConcentration) displaying on the line graph and also how derive the calculated variance. below is a sample of my data set. thanks

[pras_135]

It is possible to do this now in power bi. Use the "Add further Analysis to your Visual" as seen in the below image. Use the add constant y-axis line, and add the required measures. 

For 1SD, use the formula average + sd,and so on...

[dmf]

I see how this could work for plotting the SD for one batch of QC. Is there a way to plot multiple batches of QC?

For example:

I have a series of 5 batches of QC I used from June'23 to Jan'24. I would like to plot the 3SD from each batch as a contiguous line across time on X. I sort of have it but I want my contiguous line to shift Y-axis value on the date the QC batch changed, not in the middle of two QC batches.

Desired Output:

This is a line graph using calendarauto(). The QC batch table consists of single dates where the batch was put into operation whereas the run data consists of different dates overlapping and in between dates of the batch QC.

Thanks for any help!

Dino

[v-yulgu-msft]

Hi @all4ephraim ,

Please show us your desired output. And show us how to calculate Standard deviation and mean with examples in your scenario.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu