Help Creating Control Chart From Simple Dataset

[phcaptjim]

Hello - I am trying to create a control chart from a very basic data set (report_month and risk_score).  I've watched a few videos and read a few articles and I have a general idea how to do this but none of my research has landed on the right approach.  I'm hoping someone can lend some assistance.  Sample files can be found at the link below.

https://drive.google.com/drive/folders/1D4ylEOJWhBXXs0wztG3c-3yMnB0dysFJ?usp=sharing 

For my central line, I want this to represent the average of the first two years of my dataset (2022 and 2023)  The dataset goes from 2022 to 2025.
Upper and lower bounds should 3 standard deviations from the central line.

Also - as an added bonus I would like to create another control chart using the same dataset but this one would be a p-chart where the upper and lower limits move based on the population size.  That calculation is a bit more complicated.

Any help with either chart is greatly appreciated!  Thank you!

[v-achippa]

Hi @phcaptjim,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Jai-Rathinavel, @lbendlin and @Praful_Potphode for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @phcaptjim,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[Praful_Potphode · Accepted solution]

Hi @phcaptjim 

 Please find sample PBIX at location.

Visuals look like below:

All the dax formulas are mentioned in the PBIX.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Jai-Rathinavel]

@phcaptjim  The dataset provided and the requirement in the image is confusing. Can you please elaborate the requirement ? I can only see risk_score and month in the dataset you provided. How is defects and sample size is derived ?

[phcaptjim]

Thanks @lbendlin for the tips.  I've attached a link that has a sample XLSX and PBIX file.

[lbendlin]

Upper and lower bounds should 3 standard deviations from the central line.

Your data is way too volatile for that.  The standard deviation is already 25.67

This process is not controllable that way.

what's the expected population size for the second part?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...