Creating S-curve visual in Power BI

[PrimaSatria]

Dear all,

I need to create a visual of S-curve. 
I have measure of Plan, Actual, CumPlan and CumActual, and also the Date
But when try to visual it, the result is not an S-curve.

Below the measures:

SumPlan = SUM('Table1 (2)'[WEIGHT (TON)])

SumActual = SUM('Table1 (2)'[ACTUAL])

CumPlan = CALCULATE([SumPlan],

    FILTER(ALLSELECTED('Table1 (2)'[RITRA LOCATION DATE]),

        'Table1 (2)'[RITRA LOCATION DATE] <= MAX('Table1 (2)'[RITRA LOCATION DATE])

    )

)

CumActual = CALCULATE([SumActual],

    FILTER(ALLSELECTED('Table1 (2)'[RITRA LOCATION DATE]),

        'Table1 (2)'[RITRA LOCATION DATE] <= MAX('Table1 (2)'[RITRA LOCATION DATE])

    )

)

I need your kind help and assistance to solve this problem.

Thank you very much
prima

[JamesLee94]

To create an S-curve in Power BI, add a cumulative measure for progress over time and plot it on a line chart against planned progress. Use DAX to calculate cumulative values and format the chart with smooth lines to clearly show the S-shaped trend.

[PrimaSatria]

Dear DataVitalizer,

I'm just a newbie in Power BI, can you explain in detail about using Calendar Table over [Ritra Location Date]

Thank you,
prima

[v-menakakota · Accepted solution]

Hi  @PrimaSatria  ,
Thanks for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @JamesLee94  and @DataVitalizer  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team 

[v-menakakota]

Hi @PrimaSatria ,

Can you please confirm whether the issue has been resolved. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need. 

Thank you.

[v-menakakota]

Hi @PrimaSatria  ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[DataVitalizer]

Hi @PrimaSatria 

Here are two suggestions

• Use a Calendar Table for better control over [RITRA LOCATION DATE]
• Instead of using ALLSELECTED, use REMOVEFILTERS or ALL to get more consistent cumulative logic

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge