Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Last value point on line chart

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[Da...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    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's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      5 years ago

      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] )