Forum Discussion

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
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.

Anonymous

Not applicable

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.