Urgent requirement to plot chart using latest valu...

Hello

I have a Stream Analytics job setup that takes data calculated on the fly from an event hub and pumps it into power bi

Each item that I plot is a value for a line chart.  These values get recalculated.  So I may have 2 values that relate to 04:00

One has been calculated at 04:15 with a value of 100 

The second has been calculated at 04:30 with a value of 200

I need to tell Power BI to only plot the values that have the latest Calculated Date Time - in this case, only plot 200

However, as Power BI saves its data it ends up plotting both points

This is causing me major problems!

I need to use Stream Analytics as my user wants a live refresh

I have tried various combinations in Q&A but none of them work

I have spent hours on this and I am now getting anywhere as well as losing a lot of time and my deadline is getting closer

Really hope someone can help me urgently!