Forum Discussion

EL_C's avatar
EL_C
Regular Visitor
4 years ago

Line Chart data labels at last data point?

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:...
Need Help
Show and Tell
Tips and Tricks
EL_C's avatar
EL_C
Regular Visitor
4 years ago

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. 

 

SalesMonth
$400Jan-2022
$600

Feb-2022

$800Mar-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%20right%2Dclick,Name%20or%20Category%20Name%20box.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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's avatar
    EL_C
    Regular Visitor
    4 years ago

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