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[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?

 

 

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.

5 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    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
    Super 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
        Super 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] )