Colorizing/formatting a line up to today's date

[Anonymous]

I want to color the line of a chart up to a defined date. The rest of the line should be dashed.
For this I have already created two lines and superimposed them to format them differently. However, the end of the first line is disturbing, because a horizontal line is created.
Is it possible to hide the tail? or to format the same line to defined data sections?

[ppm1]

You can hide the blue "tail" by updating your measure so it returns blank for those points (e.g., Year > 2023 or Date > TODAY()).

Pat

[Anonymous]

Thank you for your message @ppm1 . What should I change?

Running Total Cost Today =

CALCULATE (

    SUM ( PCT[Actual Total Cost (€)] ),

    FILTER (

        ALLSELECTED ( 'PCT' ),

        'PCT'[Period] <= MAX ( 'PCT'[Period] )

            && 'PCT'[Period].[Date] <= TODAY ()

    )

)

[ppm1]

Please try this measure instead. Note also that filtering a whole table is not best practice, so I removed that too.

Running Total Cost Today =
VAR maxdate =
    MAX ( 'PCT'[Period] )
RETURN
    IF (
        maxdate <= TODAY (),
        CALCULATE ( SUM ( PCT[Actual Total Cost (€)] ), 'PCT'[Period] <= maxdate )
    )

Pat