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.

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.