Skip to main content
Microsoft Idea

Power BI

Needs Votes

Streaming Analytics - charts that show only the last [x] number of data points that streamed in

Vote (54) Share
taylor's profile image

taylor on 05 Dec 2015 00:13:15

When streaming data into Power BI from Stream Analytics, if you display the data in a line chart, it will accumulate until there is so much data in your chart that you can't read it. There should be an option to limit the chart to show just the most recent [x] number of data points. You could base this off of the System.TimeStamp value produced in the Stream Analytics SQL Query.

Comments (5)
taylor's profile image Profile Picture

jerry on 05 Jul 2020 22:55:21

RE: Streaming Analytics - charts that show only the last [x] number of data points that streamed in

Agreed that this is necessary at both the dashboard and report levels. same thing with Table Data Modeling

taylor's profile image Profile Picture

Lars Kemmann on 05 Jul 2020 22:43:02

RE: Streaming Analytics - charts that show only the last [x] number of data points that streamed in

Agreed that this is necessary at both the dashboard and report levels.

taylor's profile image Profile Picture

Lars Kemmann on 05 Jul 2020 22:43:02

RE: Streaming Analytics - charts that show only the last [x] number of data points that streamed in

Also it's really hard to figure out the magic words to get Q&A to show what I want. Give me a filter that I can adjust myself! "Most Recent"/"Oldest" toggle + numeric input + "Seconds"/"Minutes"/"Hours"/"Days" toggle -- that's all I ask! :)

taylor's profile image Profile Picture

Power BI User on 05 Jul 2020 22:25:22

RE: Streaming Analytics - charts that show only the last [x] number of data points that streamed in

We definitely need this at the report level. Today we are using it at Q&A level to show last 24 hour data at the dashboard level but to drill down to the report level it loses the context and confuses the audience.

taylor's profile image Profile Picture

Jonas Claessens on 05 Jul 2020 22:13:25

RE: Streaming Analytics - charts that show only the last [x] number of data points that streamed in

So far I have found, you can do an Q&A on the dataset with "from last minute". this will show you only the last values. How ever I would also like to get this feature in a Report, and in a much easier way.