Summarising daily data into weeks not working

[Anonymous]

Hi All, 

I have a Fact table that is linked to a date dimension table. I'm trying to visualise daily data on a weekly axis so i've created a relationship between the two date columns in my Date table and my Fact table and then pulled in Start of Week in the x-axis. 

However, my graph isn't adding up correctly. It's meant to show average forecast and it's always meant to add up to 100%, however, when i pull in the Start of the Week column in the x-axis, it stops at 60%. When i remove it and use the Date column from my Fact table, it adds to 100%. 

Please find PBIX attached. 

Does anyone know how i can fix this? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could create a column "weeknum".

weeknum = WEEKNUM('Date Dimension'[Date],2)

Then use this weeknum column as x-axis.

Best Regards,

Jay