Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Hi @dcg38524
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.
Hi @dcg38524
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |