Basic Control Chart creation in Power BI

Question

Hello,&nbsp;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.&nbsp;Laterly there been a request to produce a control chart using 2019 rejected results based on previous 2018 rejections.&nbsp; 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 .&nbsp;&nbsp;I am just not satisfied having to use excel and would love to see a real solution in Power BI.&nbsp;Below is a snapshot and example of data being used to product the control chart, Any advice &amp; help would be greatly appreciated,&nbsp;Kind regards,Don&nbsp;&nbsp;CLOSED_DATE&nbsp;&nbsp; CHANGE_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACTION&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Week7/1/2019 13:16CRQ000000657520Approved2019277/1/2019 13:16CRQ000000657520Approved2019277/4/2018 6:44CRQ000000081596Approved2018271/14/2019 2:17CRQ000000663989Approved201939/25/2018 8:15CRQ000000105257Approved2018395/16/2018 14:14CRQ000000140710Approved2018207/23/2018 15:49CRQ000000142235Approved20183010/9/2018 12:17CRQ000000469675Approved20184111/29/2018 9:07CRQ000000650609Approved20184811/29/2018 9:07CRQ000000650609Approved2018485/31/2018 13:47CRQ000000323110Rejected2018221/20/2018 8:43CRQ000000342207Approved201836/5/2018 13:00CRQ000000346351Approved2018233/16/2018 10:50CRQ000000350383Approved2018115/18/2018 6:54CRQ000000346903Approved2018202/19/2018 13:33CRQ000000351456Approved2018811/30/2018 21:16CRQ000000375003Approved2018488/10/2018 14:19CRQ000000386243Approved2018325/24/2018 16:06CRQ000000394727Approved2018213/8/2018 6:44CRQ000000403527Rejected2018106/21/2018 15:06CRQ000000403227Approved201825

v-juanli-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
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.
&nbsp;

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

Forum Discussion

Basic Control Chart creation in Power BI

2 Replies

Related content

Version control

Basics Of Filter

Report creation

Basic DAX Issue

New connection Creation

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