Show only last data label in a line chart

[Hugo999]

dears!

I have a line chart where i want to show only the label of the last value. This works fine in this situation:

If i de-select 2411 in the slicer the "last value" is not being shown. I would have expected that the last value is beeing shown.

What is the best way to accomplish this?

so far i am using a measure to display the last value:

lastval_%xy =

VAR LastIndex =

    MAXX(

        FILTER(ALL('KPI'[Monat]), NOT(ISBLANK('KPI'[Monat]))),

        'KPI'[Monat]

    )

VAR CurrentIndex = SELECTEDVALUE('KPI'[Monat])

VAR LastDAUValue =

    CALCULATE(

        MAX('KPI'[ProZ_DAU]),

        'KPI'[Monat] = LastIndex

    )

RETURN

    IF(

        CurrentIndex = LastIndex,

        LastDAUValue,

        BLANK()

    )

thank you for you assistance!

[SamWiseOwl · Accepted solution]

    MAXX(

        FILTER(ALLSelected('KPI'[Monat]), NOT(ISBLANK('KPI'[Monat]))),

        'KPI'[Monat]

    )

All removes internal and external filters.

If you use AllSelected it will keep the slicer filter .

[Hugo999]

thank you, this worked 🙂 😘