Forum Discussion
Disable aggregation on visualisation
Hi there,
I'm trying to analyze output of load-testing tool by PowerBI - it's simple dataset [unix timestamp; endpoint tag; execution time; status code], but for some reason I can't get an option to show Y-axis data as not aggregated for Line chart exec_time(timestamp). Following previous discussion I transformed all data to number formats instead of text but nothing changes. All summarization at Data view are disabled also for all columns
I gladly use Excel for this, but 35M rows is too much for it 😄
UPD: found out, that there are rows with the exact same timestamp because of parallel execution. Could this be an issue here?
Black_HobbiT Correct, that is your issue. I suggest either removing the duplicate rows in Power Query Editor or using an aggregation like Average or Max or Min instead of Sum.
2 Replies
Black_HobbiT Correct, that is your issue. I suggest either removing the duplicate rows in Power Query Editor or using an aggregation like Average or Max or Min instead of Sum.
Greg_Deckler thanks for quick reply, can you clarify point of aggregation in that case - is Average agg for execution time will be AVG(*exec_time) for same timestamp or this is much more complicated?
UPD: I manage to receive unaggregated visualization by chosing Scatter Chart instead of Line Chart even with dupplicates on timestamps - so, looks like if plotting style is "vector" instead of "raster" it is much more demanding for data "quality"
