Any way to only display the latest value on a chart

[Anonymous]

I have a data source where different projects inputs a weekly status report. I want to make a pie graph that only captures the latest status from each projects. Is there any way I can do this? I am still new to BI, so more indepth explanation will be appreciated. 🙂

[daxer-almighty]

Create a table out of the one above in Power Query that will only grab the rows you want. This is the easiest way to achieve what you want. Also the most efficient from the DAX perspective.