cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Responsive Resident
Responsive Resident

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
Route217
Responsive Resident
Responsive Resident

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 @Route217 ,

 

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
Route217
Responsive Resident
Responsive Resident

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 @Route217 ,

 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.