Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Control Charts

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 

MicrosoftTeams-image (2).jpgMicrosoftTeams-image (1).jpgMicrosoftTeams-image (3).jpgMicrosoftTeams-image.jpg

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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

 

View solution in original post

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

 

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
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.