Last value point on line chart

[Anonymous]

Hi Power BI Community!

I want to show the last value on the chart like this: 

and it works with this measure: 

Todays Value = var maxdate = CALCULATE(MAX(Dates[Date]),ALLSELECTED(Dates[Date]),FILTER(Dates,Dates[Date]=TODAY())

)return IF(MAX(Dates[Date])=maxdate, [Measure])

BUT if I use the date slicer the value points disappear. I think it is because I use TODAY() which measure can I use?

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to create a measure like this:

Last Value =
IF (
    MAX ( Dates[Date] ) = MAXX ( ALLSELECTED ( 'Dates'[Date] ), 'Dates'[Date] ),
    [Measure]
)

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

@Anonymous 

Take a look at this post discussing the topic.

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464

[jdbuchanan71]

@Anonymous 

When if you try it without TODAY()?

Todays Value =
VAR maxdate =
    CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates[Date] ) )
RETURN
    IF ( MAX ( Dates[Date] ) = maxdate, [Measure] )

[Anonymous]

@jdbuchanan71 Thanks for your response but the measure is not the solution:

[jdbuchanan71]

@Anonymous 

I see where I went wrong, my ALLSELECTED was too narrow.  I think this will give you what you are looking for without having to iterate all of the selected dates.

Todays Value =
VAR maxdate =
    CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates ) )
RETURN
    IF ( MAX ( Dates[Date] ) = maxdate, [Measure] )