PowerBI: Last 3 Non Blank Values from column

Question

I have a table where I get the status of the employees tasks day by day.

As in below image I get the values(Confidential, so just entered dummy data).

Then I did unpivoted the dates column and made a copy of that and split with space so that I can get the date value.

Here I would like to show the last 3 commented values in a table visualization for each task.

Like as in above image, if the 5/31/2017 value is not available, then it should get the values of 5/29/2017 plan, 5/29/2017 actual, 5/30/2017 plan values i.e nothing but the last 3 non blank values.

Any suggestions please.

Mohan V

Answer 1

I think i got the solution. I did mentioned in Top N filtering of visual level filter of fields.

And it worked for me.

Thanks for the hint @user5226582