streaming dataset show last non null

Question

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:&nbsp;show last capacityupd-amp-prod by createdat&nbsp;&nbsp;Returns a resultCreatedAt&nbsp; &nbsp; &nbsp;MinPower&nbsp; &nbsp; MaxPower31-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21,531-10-08:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19,530-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,7530-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,029-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21,5&nbsp;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.&nbsp;How can i do this?

fredborg · Answer

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:&nbsp;show last capacityupd-amp-prod by createdat&nbsp;&nbsp;Returns a resultCreatedAt&nbsp; &nbsp; &nbsp;MinPower&nbsp; &nbsp; MaxPower31-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21,531-10-08:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19,530-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,7530-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,029-10-12:00&nbsp; &nbsp; &nbsp; &nbsp;0,75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21,5&nbsp;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.&nbsp;How can i do this?

v-ljerr-msft · Answer

Hi&nbsp;fredborg,
&nbsp;
After a few research and test, I don't think there is a way to do it with QA currently. Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature.&nbsp;:smileyhappy:
&nbsp;
Regards

Forum Discussion

streaming dataset show last non null

2 Replies

Related content

Streaming Datasets

onelake for streaming datasets

Streaming Dataset

Streaming dataset

Streaming Dataset Failure