Forum Discussion
Line chart without aggregate values
Is there not a way to disaggregate value data on a line chart? I want to plot hourly data on a daily line chart like the chart below. So each day will have 24 plots. But I cannot use a "Do not aggregrate" option for the values, only an aggegration like "average". That would be fine if I wanted the daily average for the value but I want all the values for a single day plotted for that day. I don't want to zoom either to the hour level on the x-axis either.
So far the only solution I think of is to create measure to calculate the average for each hour. e.g
AvgHourly_Hour4 =
CALCULATE(
AVERAGE('Data'[Value]),
'Date'[Hour] = 4
)
(so 24 measures in total) and plotting them as series on the line chart.
Hi ashamsuzzoha ,
You could apply Hour to Legend pane.
Refer to these for further help.
https://community.powerbi.com/t5/Desktop/Do-not-sum-line-chart-Values/m-p/794565
https://community.powerbi.com/t5/Desktop/How-to-show-value-instead-of-aggregate/m-p/122327
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi ashamsuzzoha ,
You could apply Hour to Legend pane.
Refer to these for further help.
https://community.powerbi.com/t5/Desktop/Do-not-sum-line-chart-Values/m-p/794565
https://community.powerbi.com/t5/Desktop/How-to-show-value-instead-of-aggregate/m-p/122327
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Oh, that's exactly what I was looking for! Can't believe I overlooked that.
Thanks!
that, or use calculation groups. This really is a multi party conflict between your valid business reason, the rendering's engine enforced limits, and the screen resolution. You cannot technically see all your data points, so mindful aggregation will not make the user experience worse.
