Plotting a line joining first and last reading

[samanthawongg]

Hi,

I have a table that consists of the columns Settlement and Date. I have plotted Settlement as the y-axis and Sample Date as the x-axis. Now, I want to plot a line that joins the first reading and the last reading (as shown on the red line). How do I achieve this in PowerBI?

Thank you!

[samanthawongg]

It worked well, thank you!

[swikritee_p · Accepted solution]

@samanthawongg , 

Create a measure with help from index function 

var min_ = index(1,allselected(Date[Date]), Orderby(Date[Date],asc) )
Var max_ = index(1,allselected(Date[Date]), Orderby(Date[Date],desc) )

return 

if(Max(Date[Date]) = Min_ || Max(Date[Date])  =Max_ , [Your measure], blank())

You can refer this video from Amit on index function: 

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U