Forum Discussion
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:
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?
5 Replies
EL_C , I have done something in past, not sure if the same can work in this case
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%20right%2Dclick,Name%20or%20Category%20Name%20box.
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.
