Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Experts
I am new to PBI and need some guidance on how to create an S curve in PBI for forecast and actual execution tracking
I have my data like the sample below :
Release | Run ID | Run Name | Status | Exec Date | Test Set ID | Planned Execution Date |
22R4 | 143216 | RUNA | No Run | 26-09-2022 | 96109 | 21-09-2022 |
22R4 | 143868 | RUNB | No Run | 28-09-2022 | 96109 | 21-09-2022 |
22R4 | 143867 | RUNC | Passed | 30-09-2022 | 96109 | 21-09-2022 |
22R4 | 143866 | RUND | No Run | 28-09-2022 | 96109 | 22-09-2022 |
22R4 | 143865 | RUNE | Passed | 30-09-2022 | 96109 | 22-09-2022 |
22R4 | 143864 | RUNF | No Run | 28-09-2022 | 96109 | 22-09-2022 |
22R4 | 143863 | RUNA | No Run | 28-09-2022 | 96109 | 23-09-2022 |
22R4 | 143862 | RUNB | No Run | 28-09-2022 | 96109 | 23-09-2022 |
22R4 | 143861 | RUNC | Passed | 30-09-2022 | 96109 | 23-09-2022 |
22R4 | 143860 | RUND | No Run | 28-09-2022 | 96109 | 24-09-2022 |
22R4 | 143859 | RUNE | Passed | 30-09-2022 | 96109 | 24-09-2022 |
22R4 | 143858 | RUNF | No Run | 28-09-2022 | 96109 | 24-09-2022 |
22R4 | 143857 | RUNA | No Run | 28-09-2022 | 96109 | 24-09-2022 |
22R4 | 143856 | RUNB | Failed | 28-09-2022 | 96109 | 24-09-2022 |
22R4 | 143855 | RUNC | Failed | 28-09-2022 | 96109 | 24-09-2022 |
22R4 | 143854 | RUND | Failed | 28-09-2022 | 96109 | 25-09-2022 |
22R4 | 143853 | RUNE | No Run | 28-09-2022 | 96109 | 25-09-2022 |
22R4 | 143852 | RUNF | No Run | 28-09-2022 | 96109 | 25-09-2022 |
22R4 | 143851 | RUNA | No Run | 28-09-2022 | 96109 | 25-09-2022 |
22R4 | 143874 | RUNB | Blocked | 28-09-2022 | 96109 | 25-09-2022 |
22R4 | 143873 | RUNC | Blocked | 28-09-2022 | 96109 | 26-09-2022 |
22R4 | 143872 | RUND | Blocked | 28-09-2022 | 96109 | 26-09-2022 |
22R4 | 143871 | RUNE | Passed | 30-09-2022 | 96109 | 26-09-2022 |
22R4 | 143870 | RUNF | No Run | 28-09-2022 | 96109 | 26-09-2022 |
22R4 | 143869 | RUNA | No Run | 28-09-2022 | 96109 | 26-09-2022 |
22R4 | 143065 | RUNB | No Run | 26-09-2022 | 96109 | 27-09-2022 |
22R4 | 143064 | RUNC | No Run | 26-09-2022 | 96110 | 27-09-2022 |
22R4 | 143063 | RUND | No Run | 26-09-2022 | 96110 | 27-09-2022 |
22R4 | 143062 | RUNE | No Run | 26-09-2022 | 96110 | 27-09-2022 |
22R4 | 143061 | RUNF | No Run | 26-09-2022 | 96110 | 27-09-2022 |
22R4 | 143060 | RUNA | No Run | 26-09-2022 | 96110 | 28-09-2022 |
22R4 | 143071 | RUNB | No Run | 26-09-2022 | 96110 | 28-09-2022 |
22R4 | 143070 | RUNC | No Run | 26-09-2022 | 96110 | 28-09-2022 |
and wish to have S curve something like below to explain " Initial Plan -> Green line " , "Latest Forcast -> Blue Line ", and "passed, failed, blocked " to be summaries in column candle per date.
column "Exec date " to be updated as per actual so expect the latest forecast to react accordingly. Also, test set ID to be added as a slicer to filter the " X-Axis " dates range.
any detailed explanation/reference PBIX is welcome.
BR,RKP
Hi, @rakikumarpatra ;
Sorry I don't understand your logic very well, I don't see Initial Plan, Latest Forcast, etc. from your data, so it's difficult to correspond to the results you want to output
Can you share a result that you wish to output combined with your data? This makes it easier to understand your logic
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Thanks for your reply.My Bad is that I wasn't able to explain my requirement correctly.
So, in general, I am not aware of how many measures / Column we need to add to plot the S curve like the way I captured from an example. I have RAW data with columns name "
Release | Run ID | Run Name | Status | Exec Date | Test Set ID | Planned Execution Date |
above apart from what all needed to plot the graph ( S curve ) for the Initial plan, latest forecast etc is my query .
Br,RKP
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |