Is it possible to have multiple actual vs. target s-curves in the same visual?

[nikkirai]

I have an s-curve graph that compares actual vs. target sales for Quarter 1 of the year. I have created a measure like this:

Cumulative Sum Actual =
VAR CurrentQtr = MAX('Table'[Quarter])

RETURN

CALCULATE(SUM('Table'[Sales),

FILTER(

           ALLSELECTED('Table'), 'Table'[Quarter] = CurrentQtr && 'Table'[SalesDate] <=MAX('Table'[SalesDate])
     )
)

How do I combine Q1 s-curve with Q2, Q3, Q4 in the same visual? Do I need to create a measure for each quarter?

Thanks!

[Anonymous · Accepted solution]

HI @nikkirai,

I'd like to suggest you extract the quarter field to use with valued function, then these calculation will as be grouped by quarter and autofit with different quarters.

Cumulative Sum Actual =
VAR CurrentQtr =
    MAX ( 'Table'[Quarter] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[SalesDate] <= MAX ( 'Table'[SalesDate] )
        ),
        VALUES ( 'Table'[Quarter] )
    )

Regards,

Xiaoxin Sheng

[lbendlin]

yes