Control Charts

[Anonymous]

Hi Experts (see images)

I have found the following link on the web, which look at outlayer and variance in data point based on STD to work out the Upper and lower limits and averagex on your data.

Link: https://exceleratorbi.com.au/six-sigma-control-charts-in-power-bi/

Link: https://towardsdatascience.com/how-to-create-a-control-chart-in-power-bi-fccc98d3a8f9 

The above article uses the STD calculation to set the upper and lower limits, the true calculation uses something called the median moving range (Upper Limit: Multiply MEDIAN Moving Range by 3.14 and add product to average)

and 

(Lower Limit: Multiply MEDIAN Moving Range by 3.14 and subtract product from average)

and in order to calculate the Median Moving Range you need to find the differences between each pair of successive values; then sort the differences in numerical order; then identify the middle value.

Has anyone done this...

See atatched sample file...

https://www.dropbox.com/s/ztfhicjnxeq5f8k/SPC%20Sample%20Datat.pbix?dl=0 

NOTE i have not added the order Range as i would like to do this using DAX - not sure how (help) - the end result should the graph showing upper and lower bands with plot...

see images of requirement 

[Anonymous · Accepted solution]

I have made progress with the file. I just have one issue not sure how to calculate the Upper and Lower Band Dynamically based on the data set. As you can see i have cheated by putting in a fixed value as a calculated column into the data...

New link

https://www.dropbox.com/s/ztfhicjnxeq5f8k/SPC%20Sample%20Datat.pbix?dl=0

[Anonymous · Accepted solution]

I have made progress with the file. I just have one issue not sure how to calculate the Upper and Lower Band Dynamically based on the data set. As you can see i have cheated by putting in a fixed value as a calculated column into the data...

New link

https://www.dropbox.com/s/ztfhicjnxeq5f8k/SPC%20Sample%20Datat.pbix?dl=0

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Glad to hear that you have worked it out.Thanks for your sharing.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Liang can you assist been stuck on this question for 2 days 

https://community.powerbi.com/t5/Desktop/Add-Percentage-Values-based-on-External-Sales/m-p/1683267#M...