Forum Discussion
Levey Jenning Standard Deviation
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...
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