Basic Control Chart creation in Power BI

[Anonymous]

Hello,

I am new to Power BI and have some success with basic calculations and reports only with 2x Global Knowledge training classes and advice with others within this Power BI forum.

Laterly there been a request to produce a control chart using 2019 rejected results based on previous 2018 rejections.  Needless to say I can easily produce this type of request using excel and to be honest currently I am importing excel figures to achieve this request . 

I am just not satisfied having to use excel and would love to see a real solution in Power BI.

Below is a snapshot and example of data being used to product the control chart, Any advice & help would be greatly appreciated,

Kind regards,

Don

CLOSED_DATE   CHANGE_ID            ACTION    Year    Week

7/1/2019 13:16	CRQ000000657520	Approved	2019	27
7/1/2019 13:16	CRQ000000657520	Approved	2019	27
7/4/2018 6:44	CRQ000000081596	Approved	2018	27
1/14/2019 2:17	CRQ000000663989	Approved	2019	3
9/25/2018 8:15	CRQ000000105257	Approved	2018	39
5/16/2018 14:14	CRQ000000140710	Approved	2018	20
7/23/2018 15:49	CRQ000000142235	Approved	2018	30
10/9/2018 12:17	CRQ000000469675	Approved	2018	41
11/29/2018 9:07	CRQ000000650609	Approved	2018	48
11/29/2018 9:07	CRQ000000650609	Approved	2018	48
5/31/2018 13:47	CRQ000000323110	Rejected	2018	22
1/20/2018 8:43	CRQ000000342207	Approved	2018	3
6/5/2018 13:00	CRQ000000346351	Approved	2018	23
3/16/2018 10:50	CRQ000000350383	Approved	2018	11
5/18/2018 6:54	CRQ000000346903	Approved	2018	20
2/19/2018 13:33	CRQ000000351456	Approved	2018	8
11/30/2018 21:16	CRQ000000375003	Approved	2018	48
8/10/2018 14:19	CRQ000000386243	Approved	2018	32
5/24/2018 16:06	CRQ000000394727	Approved	2018	21
3/8/2018 6:44	CRQ000000403527	Rejected	2018	10
6/21/2018 15:06	CRQ000000403227	Approved	2018	25

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I find a similar thread of yours and replied there.

https://community.powerbi.com/t5/Desktop/Control-Chart-UCL-LCL-of-Rejected-Category/td-p/812867

Please check if my understanding is correct, if it doesn't solve your problem, please let me know.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Maggie,

Using the same information posted in this thread would you know how I can calculate Std Deviation?

Below example does not work at all:

StdDev=calculate(STDEV.P(RejectedClosure[%_2018]), ALL(RejectedClosure[Week of Year]))

Thanks again,

Don