streaming dataset show last non null

I have a streaming dataset, where i can query my data using the "ask questions" functionality. Now, when i tell powerbi to only show the last capacityupdate event we have in the system, it always wants to show me the last 5. I only want to see 1:

show last capacityupd-amp-prod by createdat 

Returns a result

CreatedAt     MinPower    MaxPower

31-10-12:00       0,75            21,5

31-10-08:00       0,75            19,5

30-10-12:00       0,75            0,75

30-10-12:00       0,0               0,0

29-10-12:00       0,75            21,5

I want to show the latest value (The top most row) in a Gauge on my dashboard. So that MaxPower is set to Maximum value, and MinPower is set to Minimum value.

How can i do this?