Forum Discussion

Nihed's avatar
Nihed
Helper III
4 years ago
Solved

Help

Hello,

Someone can help me please, how I can add  number of the latest value at the end of the chart ?

as I showed in the picture:

Thank you

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Nihed ,

     

    From what I understand, you only want to show the data labels for the last month's value in the line chart, right?

    Please create a measure:

    Measure = 
var _maxMonth= MAXX(ALL('Table'),MONTH([Date]))
return CALCULATE(SUM('Table'[Value]),FILTER('Table',MONTH([Date])=_maxMonth))

    And apply it to Values field as well, then enable the Customize series option as the blog provided by amitchandak mentioned:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies