Forum Discussion
Julier
Helper III
Helper IIIEnd 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. ...
JulierHelper III
Helper IIIHi, 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
BeaBF
Super User
Super UserJulier 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:
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