Forum Discussion
End data labels
I need to be able to add just the end data labels to this chart, the days are just numbered 1-31 with the sales against each day but i cant seem to find the right measure to to do this.
12 Replies
Hi, Im unable to share the file as its part of a bigger dashboard, i just want to be able to show the number on the final day so it will just show 32M for 2022 and 31M for 2023 at the ned of the lines and not have the labels at every point throughout the month
Julier Ok, so you need to calculate a measure like:
LABEL_LINE =VAR LastMonth = CALCULATE(MAX(Table[MONTH]), ALL(Table[MONTH]))RETURN IF(SELECTEDVALUE(Table[MONTH] = LastMonth , YOUR CALCULATION, BLANK())
Then put this measure in Data Labels > Value:you'll obtain the label only for the last value of month:
If it's OK, please accept my answer as solution to help others.
BBF
Hi Julier ,
Select your line chart, and in the format pane, in X-Axis, change the type from continuos to categorical:
Thank you but that doesnt allow me just show the end point, is htere a measure that i could use?
what you mean with "just show the end point", what end point and based on your screenshot, how the output should look like?
