Trend live graph hourly, minutely, daily like task manager performance tab

[liey87]

Hi,

How to make the graph trend like task manager without distort the graph which combine all data from dataset? I'm currently having a dataset from azure stream analytics. Therefore, it's seems to be some limitation. As client don't want to see some data that look small and stack. So, I want to make a trend data which show last 60 second until current with interval of a seconds

Yes, I mean something like this. So client can see clearly the value of data within some xx interval (hourly, 60 seconds, daily, etc).

I'm not doing the desktop as it's coming live from Stream Analytics. Is Power Bi web have this kind of features?

[v-qiuyu-msft]

Hi @liey87,

After we use Power BI as output of Azure Stream Analytics Jobs, if the Stream Analytics job query outputs results, corresponding dataset will be created in Power BI Service. As in web service, we can't do much with dataset, it's not supported to create a new column, measure or table. We can only create a report use data from current dataset. So in your scenario, I'm afraid we are not able to achieve the requirement currently.

Best Regards,
Qiuyun Yu

[liey87]

Hi @v-qiuyu-msft

I believe having a trend graph data can strengthen the visualization. Since currently if the dataset in powerBi is too many,the visual trend will be like distorting. If only PBi team can provide this, it would be great as task manager must be get latest data from the device, not inquiry from historical dataset.

Maybe we can have "show value1,value2 within an hour" or "within 1 month" or "in range" or "in between" from the Q&A in future..