Forum Discussion
Solved
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. ...
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:
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
i wasnt able to do it, can i send you the whole file i have taken this tab out of of the main dashboard but i cant see how i can send it to you?
