Creating a graph that shows variation of data weekly over a month

[Vinit0910]

Hello Everyone,

I'm working on one project. The client has requested to view the weekly average data represented in a graph for the chosen month. So, here is an example. In the image below, there is a date slicer that has a date range from Jan 01, 2025, to Jan 31, 2025, and below is the graph that has values on the Y-axis and dates on the X-axis. So I want to see weekly data, like 1st week (Jan 05), 2nd week (Jan 05), 1st week (Jan 05), 1st week (Jan 5), and an Average line passes throught it showing average of Each week data connects to the 2nd week of average data. connecting to 3rd week of average data and so on, and that create curve line

Please let me know if anyone has a query regarding the above question.

Thanks,

[v-achippa · Accepted solution]

Hi @Vinit0910,

Based on the requirement, please follow below steps to get the weekly average as a smooth line over daily data:

Create a week start column in your Date table:

Week Start Date = STARTOFWEEK('Date'[Date], 1)

Create the weekly average measure like below:

Weekly Average Sales =

CALCULATE(

    AVERAGE(FactSales[Sales]),

    ALLEXCEPT('Date', 'Date'[Week Start])

)

In the visual, use 'Date'[Date] on the X-axis, FactSales[Sales] in column, Weekly Average Sales in the line.

This calculates the average sales for each week, keeping the week context.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[Vinit0910]

Yes, I used a line chart with the start of the week on the X-axis, and I put their minimum, maximum, and average on the Y-axis. that solves my problem

[techies]

Hi @Vinit0910 as i understand, please check this

Weekly Average =

CALCULATE (

    AVERAGE ( FactSales[Sales] ),

    ALLEXCEPT ( 'date', 'date'[week start date] )

)

[Vinit0910]

Thanks for the answer. I applied the DAX solution, but the column chart and line chart, or any chart, do not allow me to put this measure in the axis.

[SreeniBattula]

Create Week column  and concatinate with  month and choose this  column in X-axis