Line Chart data labels at last data point?

[EL_C]

Hi,

I know that series labels are displayable on the right or left of a line chart, but is it possible to display labels at the last data point for a given line? Here's an example of what I mean:

The client would like to see Labels 1/2/3 with dollar amounts.

Data will be dynamic based on selection from a slicer, so static textboxes will not work.

Thoughts? Suggestions? Workarounds?

[amitchandak]

@EL_C , I have done something in past, not sure if the same can work in this case

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Lin...

[EL_C]

This is close, but not exactly what I'm after. I need to display more than the dollar value, I need to show the name of the series as well.

So if I have the following table, and Sales is on the y-axis and Month is on the x-axis, I need a label that shows "Sales, $800," for Mar-2022. 

Sales	Month
$400	Jan-2022
$600	Feb-2022
$800	Mar-2022

Here is an example of the functionality I'd like to see: https://depictdatastudio.com/directly-labeling-line-graphs/#:~:text=In%20Microsoft%20Excel%2C%20righ....

[amitchandak]

@EL_C , for that, refer if this custom label can help

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw

[v-zhangti]

Hi, @EL_C 

Normally, you can't add "point" to a line chart. But you can try to create a measure to get the value for March and the other months as blank. You can try the following methods.

Measure = 
Var N1=CALCULATE(MAX('Table'[Month]),ALL('Table'))
Var N2=CALCULATE(MAX('Table'[Sales]),FILTER(ALL('Table'),[Month]=N1))
return
IF(SELECTEDVALUE('Table'[Month])=N1,N2,BLANK())

Open data tab for Measure only.

Does this resemble the results you expect?

Best Regards,

Community Support Team _Charlotte

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

[EL_C]

Hi, thanks for your response, @v-zhangti . Unfortunately this is a similar, if not the same, solution as the one provided by @amitchandak, which only showed the dollar amount on the chart, and not the series title. 

Using your example, the solution I'm looking for is for the label to read "Sales, $800".