Forum Discussion

PrimaSatria's avatar
PrimaSatria
Regular Visitor
1 year ago
Solved

Creating S-curve visual in Power BI

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


Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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 

6 Replies

  • DataVitalizer's avatar
    DataVitalizer
    Icon for Super User rankSuper User
    1 year ago

    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

  • PrimaSatria's avatar
    PrimaSatria
    Regular Visitor
    1 year ago

    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's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      1 year ago

      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's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        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.

  • JamesLee94's avatar
    JamesLee94
    Icon for Helper I rankHelper I
    1 year ago

    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.