End data labels

[Julier]

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.

[Bibiano_Geraldo]

Hi @Julier ,

Select your line chart, and in the format pane, in X-Axis, change the type from continuos to categorical:

[Julier]

Thank you but that doesnt allow me just show the end point, is htere a measure that i could use?

[Bibiano_Geraldo]

what you mean with "just show the end point", what end point and based on your screenshot, how the output should look like?

[BeaBF]

@Julier Hi! what do you mean with end data labels? can you share the Pbix file?

BBF

[Julier]

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

[BeaBF]

@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

[BeaBF]

@Julier did it work? 

BBF

[Julier]

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?

[BeaBF]

@Julier I send you my email in pvt.

BBF

[BeaBF]

@Julier I'm resending you the pbix file, my method was correct, but you had to create 3 measures and put each measure in his Value Field, by choosing "series" to which apply that label. 

If it's ok, please accept my previous answer as solution.

BBF

[Julier]

Hi, Thank you for this it works great, can you plesae just let me know how i can now only show the end label as all of my labels are still showing and i cant work out how you have done it.

[BeaBF · Accepted solution]

@Julier As you can see, you need to create a measure for each line in the chart. Then, go to Data Labels and, for each series, set the created measure as the "Value".

2022:

2023:

2024:

Accept the answer as solution!

BBF