How do I show average weekly on my graph?

[simoncotterill]

Hi, I'm new to BI so forgive me if this request is basic.

I track the availabilty of 5 different equipment types daily and show these currently on a graph. The issue is the graph looks very messy (see below)

How do I show a weekly average instead of the daily values as I think the value variation would reduce and would be easier to look at.

Thanks

[Arul · Accepted solution]

@simoncotterill ,

Create week column from date column and use it in X-axis the use the formula like this,

Week average = 
CALCULATE(AVERAGE(your column)/7,ALLSELECTED('Calendar'[Week_Year])

Thanks,