Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rakikumarpatra
Frequent Visitor

S Curve Measures and charts

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 :

 

 ReleaseRun IDRun NameStatusExec DateTest Set IDPlanned Execution Date
22R4143216RUNANo Run26-09-20229610921-09-2022
22R4143868RUNBNo Run28-09-20229610921-09-2022
22R4143867RUNCPassed30-09-20229610921-09-2022
22R4143866RUNDNo Run28-09-20229610922-09-2022
22R4143865RUNEPassed30-09-20229610922-09-2022
22R4143864RUNFNo Run28-09-20229610922-09-2022
22R4143863RUNANo Run28-09-20229610923-09-2022
22R4143862RUNBNo Run28-09-20229610923-09-2022
22R4143861RUNCPassed30-09-20229610923-09-2022
22R4143860RUNDNo Run28-09-20229610924-09-2022
22R4143859RUNEPassed30-09-20229610924-09-2022
22R4143858RUNFNo Run28-09-20229610924-09-2022
22R4143857RUNANo Run28-09-20229610924-09-2022
22R4143856RUNBFailed28-09-20229610924-09-2022
22R4143855RUNCFailed28-09-20229610924-09-2022
22R4143854RUNDFailed28-09-20229610925-09-2022
22R4143853RUNENo Run28-09-20229610925-09-2022
22R4143852RUNFNo Run28-09-20229610925-09-2022
22R4143851RUNANo Run28-09-20229610925-09-2022
22R4143874RUNBBlocked28-09-20229610925-09-2022
22R4143873RUNCBlocked28-09-20229610926-09-2022
22R4143872RUNDBlocked28-09-20229610926-09-2022
22R4143871RUNEPassed30-09-20229610926-09-2022
22R4143870RUNFNo Run28-09-20229610926-09-2022
22R4143869RUNANo Run28-09-20229610926-09-2022
22R4143065RUNBNo Run26-09-20229610927-09-2022
22R4143064RUNCNo Run26-09-20229611027-09-2022
22R4143063RUNDNo Run26-09-20229611027-09-2022
22R4143062RUNENo Run26-09-20229611027-09-2022
22R4143061RUNFNo Run26-09-20229611027-09-2022
22R4143060RUNANo Run26-09-20229611028-09-2022
22R4143071RUNBNo Run26-09-20229611028-09-2022
22R4143070RUNCNo Run26-09-20229611028-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.

 

 

rakikumarpatra_0-1665030651121.png

 

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

 

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

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 "

ReleaseRun IDRun NameStatusExec DateTest Set IDPlanned 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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.