How to plot cumulative line graph by product

Hi Anonymous ,

Sorry for the late response but I got this post lost in the middle of my other replies.

To do this you need to create a new table with the products_year and a target row use this formula:

ProductYEar = CALCULATETABLE(UNION(DISTINCT(Service[Product_Year]) , ROW("Product_Year","Target")), KEEPFILTERS(Service[Product_Year] <> BLANK())
)

Now redo your measure to :

Cumulative Hours  by month = 
SWITCH(SELECTEDVALUE(ProductYEar[Product_Year]),
"Target", 200* MAX(Months[Month]),
COALESCE (
    CALCULATE (
        SUM ( Service[Hours Diff] ),
        FILTER (
            ALLSELECTED ( Service[Time(months)], Service[Product_Year] ),
            Service[Time(months)] <= MAX ( Months[Month] )
                && Service[Product_Year] = SELECTEDVALUE ( ProductYEar[Product_Year] )
        )
    ),
    0
))

Now replace the Product Year on your line chart by the column of the new table create final result below and in attach PBIX file:

Only question you need to be carefull is that isnce the target isd part of your table you need to use the product year from the original table to have as a slicer so that the target line does not dissapear from your chart check result attach.,