Line Chart: Show only end data points for the last days

[sam_gift]

Hi,

I have a line chart, where I have different data points as the below screenshot, I am happy with the overall data points but As at the end, the numbers look clumpsy and I observed that each line have 2 data points displayed at the very end. I want to show only one data point the end of the line (for the box B) along with all the data points from box A.

Please help

[Ritaf1983 · Accepted solution]

Hi @sam_gift 

You can use conditional formatting functionality to achieve this goal.
Create the measure that returns color based on last point checking like:

maX year_color =

var

Max_yeaar=

CALCULATE(MAXX(values('Calendar'[Year]),MAX('Calendar'[Year])),ALLSELECTED('Calendar'))

return

 IF(SELECTEDVALUE('Calendar'[Year])<>Max_yeaar,"#FFFFFF00"

,"black")

Use this measure for conditional formatting of label color :

Result:

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.