Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashamsuzzoha
Helper III
Helper III

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.Screenshot 2021-01-21 145759.png

 

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.

 

 
1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

Hi @ashamsuzzoha ,

 

You could apply Hour to Legend pane.

 

1.26.2.1.PNG

 

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.

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

Hi @ashamsuzzoha ,

 

You could apply Hour to Legend pane.

 

1.26.2.1.PNG

 

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!

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.