Visualization that will sum units per each week and compare to the month total

[DIFF1]

Hello everyone, 

I have such a situation. 

I have Budget per month namely 10,704,821. 

I have Total units per week namely 1 week) 3,110,471   2 week) 3,425,498  3 week)5,434,598   4 week)4,038,218 units. 

I have decided to use clustered column chart for visualization. 

The way how it looks right now, it doesn't really provide a good insight. Is there a way to sum week1+2 results and show it as a sum. For week3 = sum week1+sum week2+ sum week3. For week4 = sum week1+week2+week3+week4. I need it to compare how we progress through the month in terms of budget vs total units. 

Is that possible?

[DIFF1]

Ashish thank you. I am not sure why but it doesn't work for me. 

I need to create only many to many relationship otherwise it doesn't work. 

MTD sales do not add up to each other. 

Do you know what I need to change?

[Ashish_Mathur]

Hi,

Share the download link of the file.  Keep only the visual in which you are facing the issue.  Remove all other pages/visuals.

[DIFF1]

Ashish thank you. Can you open the file? https://easyupload.io/pk9eka

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Ashish_Mathur]

Hi,

Ensure that you have a Calendar Table with calculated column formulas for Year, Month name, Month number and Week number.  Sort the Month name column by the Month number.  Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table.  To your visual, drag Year, Month name and Week number column to the X-axis.  Write these measures:

Sales = sum(Data[Amount])

MTD sales = calculate([Sales],DATESMTD(Calendar[Date]))

Hope this helps.