Line chart without aggregate values

[ashamsuzzoha]

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.

[Anonymous · Accepted solution]

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.

[ashamsuzzoha]

Oh, that's exactly what I was looking for! Can't believe I overlooked that.

Thanks!

[lbendlin]

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.